Just a post of things to keep in mind (for myself) when using PnP PowerShell and Azure Automation. I guess these are good things to keep in mind with PnP PowerShell in general.<\/p>\n
PnP PowerShell is great for dealing with SharePoint and I use it a lot with Azure Automation Runbooks but it also gives a bunch of errors now and then. Figuring out how to solve them has taught me a few things to keep in mind for later.<\/p>\n
1. When using cmdlets like Thanks to this GitHub issue<\/a> for pointing the way.<\/p>\n 2. I typically do a It doesn’t matter if I add in a couple of try\/ catch blocks to catch these and reconnect. I suspect this is because one of the Runbooks disconnects the connection, thus affecting the others.<\/p>\n The solution for this, it turns out, is to capture the connection in a variable and reuse that.<\/p>\n Now I can use that everywhere.<\/p>\n Since doing this, no more disconnects! Yay.<\/p>\n To eventually disconnect when quitting the Runbook don’t use <\/p>\n","protected":false},"excerpt":{"rendered":" Just a post of things to keep in mind (for myself) when using PnP PowerShell and Azure Automation. I guess these are good things to keep in mind with PnP PowerShell in general. PnP PowerShell is great for dealing with SharePoint and I use it a lot with Azure Automation Runbooks but it also gives … Continue reading PnP PowerShell and Azure Automation – things to keep in mind<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[887],"tags":[1017,769,1023],"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6996"}],"collection":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/comments?post=6996"}],"version-history":[{"count":1,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6996\/revisions"}],"predecessor-version":[{"id":6997,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/posts\/6996\/revisions\/6997"}],"wp:attachment":[{"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/media?parent=6996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/categories?post=6996"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rakhesh.com\/wp-json\/wp\/v2\/tags?post=6996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Add-PnPListItem<\/code> or Set-PnPListItem<\/code> etc. it’s good to capture the output in a variable. That is to say, do something like $output = Add-PnPListItem -<whatever><\/code>. It looks like too much output from these cmdlets can mess up Runbooks, so best to capture them in a variable.<\/p>\nConnect-PnPOnline<\/code> at the beginning of the Runbook to connect to the site. And disconnect at the end. But I suppose it is a side effect of me having multiple Runbooks in the same Automation Account and Hybrid Runbook Workers, and them perhaps conflicting with each other, very often I get errors like ‘The current connection holds no SharePoint context. Please use one of the Connect-PnPOnline commands which uses the -Url argument to connect.’<\/p>\n$pnpConnection = Connect-PnPOnline @connectParamsSPO -ErrorAction Stop -ReturnConnection<\/pre>\n
$output = Add-PnPListItem -List $spoList -Values $values -ErrorAction Stop -Connection $pnpConnection<\/pre>\n
Disconnect-PnPOnline<\/code> any more. Simply null the variable<\/a>:<\/p>\n$pnpConnection = $null<\/pre>\n