Hello,
I am cereating a Poweshell script to add data in Office 365 list on intervals.
I am able to create script sucessfully and executing it in SharePoint Online Management Shell.
This is my code.
$siteUrl = "site URL";
$listName = "List"
$userName = "user name";
$password = "password";
$SecurePassword = $password | ConvertTo-SecureString -AsPlainText -Force
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($userName, $SecurePassword)
$context = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$context.Credentials = $credentials
[Microsoft.SharePoint.Client.Web]$web = $context.Web
[Microsoft.SharePoint.Client.List]$list = $web.Lists.GetByTitle($listName)
[Microsoft.SharePoint.Client.ListItemCreationInformation]$itemCreateInfo = New-Object Microsoft.SharePoint.Client.ListItemCreationInformation;
[Microsoft.SharePoint.Client.ListItem]$item = $list.AddItem($itemCreateInfo);
$item["Title"] = "title";
$item.Update();
$context.ExecuteQuery();
I am creating one task in Task Schedular that executes script in every 5 minutes.
When I register any other local script, it works fine.
But when I register my PowerShell script that add data in Office 365 list, it neither works nor throws any error.
Can anyone suggest how can I schedule my Poweshell script for Office 365.
Be an open to give any suggestion.
Thank you
What I have tried:
Created Scheduler with this script. It works fine manually but didn't worked with scheduler