How can I insert into an existing Sharepoint task list using a Powershell script

Question

I'm in the process of creating a Web interface for requesting IT accounts. Upon submission, I want to run a Powershell script that will create an item in a Sharepoint task list.

Comments

Hello,

Sorry for the confusion, but we are not quite sure what exactly you need to achieve. However, the following script from our repository should be helpful: https://www.adaxes.com/script-repository/create-user-folder-in-sharepoint-library-s61.htm. If you still have issues writing the desired script, we recommend you to contact Microsoft support for assistance. Should you have the script working in Windows PowerShell, but struggle to run it in Adaxes, please, post here or send us (support@adaxes.com) the script and describe the desired behavior in all the possible details with live examples.

---

Hello! The script you reference is providing instructions on adding a FOLDER to a Sharepoint library. I'm interested in adding a task item to an existing Sharepoint list. Here's an example of a script that I'm trying to run that fails trying to add a PPSnapin to Sharepoint:

Import-Module Adaxes

if((Get-PSSnapin | Where {$_.Name -eq "Microsoft.SharePoint.PowerShell"}) -eq $null) {
    Add-PSSnapin Microsoft.SharePoint.PowerShell
}

try
{
    $SPWeb = Get-SPWeb "https://wakecountync.sharepoint.com/sites/AppDevTeam/"
    $List = $SPWeb.Lists["WR"]

    $newItem = $List.items.add()
    $newItem["Task Name"] = "Adaxes - Test"
    $newItem["Assigned To"] = "Sandra Mitchell"
    $newItem["Requesting Dept/Div/Team"] = "IS"
    $newItem["Requested By"] = "Fred Flintstone"
    $newItem.update()

    $SPWeb.Dispose();
}
catch
{

}

---

Hello,

For us to help you with the script, please, specify the following:

• Did you install the SharePointServer PowerShell module on the computer where Adaxes service runs?
• Did you try running the script in Windows PowerShell? Does it work fine? If you face any error messages, please, post here or send us (support@adaxes.com) screenshots.
• What exactly do you mean by fails trying to add a PPSnapin? Do you face any error messages? If you do, please, post here or send us (support@adaxes.com) screenshots.

Any additional details will be much appreciated.

---

Thanks for the reply and my apologies for being rather vague in my request.

• I have not installed the SharepointServer powershell module. I looked at the link you provided and it appears to deal with administering the Sharepoint environment, not adding items to an existing Sharepoint list
• My previous attempts at the running the script were done from the Windows Powershell ISE on a test Adaxes server.
• The error message I get is: Add-PSSnapin : No snap-ins have been registered for Windows PowerShell version 5. At C:\Users\SMitchell\Documents\WindowsPowerShell\Scripts\AddToSharepointList.ps1:4 char:5

• Add-PSSnapin Microsoft.SharePoint.PowerShell

• 
    + CategoryInfo          : InvalidArgument: (Microsoft.SharePoint.PowerShell:String) 
    [Add-PSSnapin], PSArgumentException
    + FullyQualifiedErrorId : AddPSSnapInRead,Microsoft.PowerShell.Commands.AddPSSnapin 
   Command

Answer 1

Hello,

Thank you for the provided details. The error occurs because the Add-PSSnapin cmdlet must be executed on the computer where SharePoint is installed. It will require establishing a remote PowerShell session to the computer as it is done in the script we referenced in our first comment. You can try replacing the part in the script for working with the SharePoint folder with the code for the SharePoint list update.