Automate a PowerShell script that updates information on all SharePoint sites.

Hello

Please i need your help on this issue.

My IT department has a few PowerShell scripts we are currently using to mass update various settings and user information in our SharePoint sites. Outside of running them using Task Scheduler, is there a way to automate them using Power Automate or something similar?

As a quick side question, is there a way to avoid the authentication that occurs when using Connect-SPOService?

I've tried passing in the admin credential, but receive the following error when I do:

Connect-SPOService : One or more errors occurred.

At C:\Users\Kperry\Documents\defaultopen.ps1:46 char:1

• Connect-SPOService -URL $AdminSiteURL -Credential $cred

[Connect-SPOService], AggregateException

• FullyQualifiedErrorId : System.AggregateException,Microsoft.Online.SharePoint.PowerShell.ConnectSPOService

The only way I've had the script succeed is by not passing a credential into the function. Which means I then have to manually select my login credential from the sign-in popup that appears. Without a solution to this, I feel that automating the script would be a bit pointless (as I will have to manually sign in when it runs).