Connect-PNPOnline - Automate logon

Question

I&nbsp;can&nbsp;successfully&nbsp;connect&nbsp;to SharePoint&nbsp;online&nbsp;using&nbsp;my&nbsp;admin&nbsp;account&nbsp;and&nbsp;the&nbsp;below&nbsp;command.Connect-PnPOnline&nbsp;-Url&nbsp;"https://(sitename).sharepoint.com/sites/(subsite)"&nbsp;-InteractiveDuring&nbsp;this&nbsp;process&nbsp;I&nbsp;get&nbsp;the&nbsp;interactive&nbsp;logon&nbsp;prompt,&nbsp;I&nbsp;enter&nbsp;my&nbsp;standard&nbsp;password,&nbsp;I&nbsp;complete&nbsp;the&nbsp;MFA&nbsp;prompt&nbsp;and&nbsp;I&nbsp;am&nbsp;allowed&nbsp;access.I&nbsp;need&nbsp;to&nbsp;be&nbsp;able&nbsp;to&nbsp;connect&nbsp;with&nbsp;no&nbsp;user&nbsp;prompts.I&nbsp;thought&nbsp;I&nbsp;would&nbsp;use&nbsp;an&nbsp;app&nbsp;password&nbsp;to&nbsp;avoid&nbsp;the&nbsp;MFA&nbsp;prompts&nbsp;but&nbsp;when&nbsp;I&nbsp;try&nbsp;the&nbsp;below&nbsp;command,&nbsp;enter&nbsp;my&nbsp;username&nbsp;and&nbsp;app&nbsp;password,&nbsp;power&nbsp;shells&nbsp;returns&nbsp;with&nbsp;"Error&nbsp;validating credentials&nbsp;due&nbsp;to&nbsp;invalid&nbsp;username&nbsp;or&nbsp;password".&nbsp;&nbsp;&nbsp;Connect-PnPOnline&nbsp;-Url&nbsp;"https://(sitename).sharepoint.com/sites/(subsite)"Are&nbsp;app&nbsp;passwords&nbsp;no&nbsp;longer&nbsp;support&nbsp;for&nbsp;this?What&nbsp;are&nbsp;my&nbsp;alternatives?

stevemacnz · Answer

Joshua_Thompson&nbsp;&nbsp;Hi Joshua - off the top of my head I would suggest looking into Azure Automation using runbooks&nbsp;https://docs.microsoft.com/en-us/azure/automation/manage-office-365&nbsp;has more information

vasilmichev · Answer

Use the -AppId -AppSecret parameters. You need to have a matching app registration in Azure AD.

joshua_thompson · Answer

Thanks SteveMacNZ and @Vasil for the recommendations!

Forum Discussion

Connect-PNPOnline - Automate logon

3 Replies

Resources