question

Hi @RamachandranKrishnamoorthy-8642 ,
You can refer to following script to retrieve all list items.

 #Config Parameters
 $SiteURL= "https://xxx.sharepoint.com/sites/abc"
 $ListName="test"
 $ItemTitle = "Display Name Attribute"
       
 #Setup Credentials to connect
 $Cred = Get-Credential
     
 Try {
     #Setup the context
     $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
     $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password)
         
     #Get the web and List
     $Web=$Ctx.Web
     $List=$web.Lists.GetByTitle($ListName)
        
     #Get a List item by its Title
     $Query = New-Object Microsoft.SharePoint.Client.CamlQuery
     $Query.ViewXml = "@
     <View>
         <Query>
             <Where>
                 <Eq>
                     <FieldRef Name='Title' /><Value Type='Text'>$ItemTitle</Value>
                 </Eq>
             </Where>
         </Query>
     </View>"
      
     #Get All List Items matching the query
     $ListItems = $List.GetItems($Query)
     $Ctx.Load($ListItems)
     $Ctx.ExecuteQuery()
     
     Write-host "Total List Items:" $ListItems.count
        
     #Loop through each file in the library
     Foreach($Item in $ListItems)
     {
         Write-host -f Green $Item["Title"]
     }
 }
 Catch {
     write-host -f Red "Error:" $_.Exception.Message
 }

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hi @RamachandranKrishnamoorthy-8642

This needs to be split into two sections. The first is querying Azure for the data via power shell. This article will help:

https://docs.microsoft.com/en-us/azure/governance/resource-graph/first-query-powershell

Then you need to write the data into the share point list. List article will help you with this:

https://social.technet.microsoft.com/Forums/lync/en-US/42022287-7f3a-431b-acdd-8472ad8d9926/how-to-export-powershell-script-information-to-sharepoint?forum=sharepointgeneralprevious

Also this:

https://docs.microsoft.com/answers/questions/606290/pnp-powershell-upload-csv-to-sharepoint-list.html

I hope this answers your question.

Thanks.

--If the reply is helpful, please Upvote and Accept as answer--

Hi Raytheon,

Splitting into two sections are more difficult here. We have some service accounts in AD without any telephone or mobile attribute. Extracting the data in excel brings up those service acccounts as well. I am looking into some other options as well.

Thanks,
Ram