I'm working with an account that has MFA set up and I'm trying to write a script to get me all the lists within a SharePoint Online site and its subsites.
The code works fine in the top-level site after providing MFA details, however, when I try to get the lists in the subsites the code returns the lists in the top-level site instead. This is because the connection\context I am passing is the connection for the top-level site.
I'm assuming I should be creating a new-PnP connection for each subsite but as there are a large number of subsites, I am trying to avoid re-authenticating using MFA for each subsite.
I have tried Get-PnPList with and without the -Web parameter but both times it says The current connection holds no SharePoint context. So, I am forced to use the -connection parameter and pass the $conn variable, which only holds the pre-existing context for the top-level site.
My code is as follows:
$conn = Connect-PnPOnline -ReturnConnection -Url https://test.sharepoint.com/sites/testsite $rootLists = Get-PnPList -Connection $conn $subWebs = Get-PnPSubWeb -Connection $conn foreach($subweb in $subWebs) { Get-PnPList -Web $subweb -Connection $conn #This is the bit that isn't behaving as I want. } Is there a way to re-use the MFA credentials in the original connection and pass that to a new PnP connection request to avoid having to MFA for each subsite
If 1 isn't possible. Is there a way to get the lists of a subsite without needing a new PnP connection and MFA request?
Thanks in advance.
