Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Export SharePoint list to Excel sheet.

Like (0) ShareShare
ReportReport
Posted on 8 Apr 2025 13:36:01 by 2
Hello Team,
 
Please help me to export a sharepoint list to excel for further use,
 
In my list I have more than 10k records
Few columns are Person and Group
Few columns are LookUp
Few Columns are DateTime.
 
Any referral help would be highly appreciated.
 
 
Currently I am using VB script to export all records to excel but these column values are always missing in exported excel sheet, please guide.
 
 
Thanks
AJAY
  • CU08041330-0 Profile Picture
    2 on 09 Apr 2025 at 07:19:29
    Export SharePoint list to Excel sheet.
    Thanks David,
     
    I am getting all items irrespective of how long the list is now, The only problem I face is given below.
     
    1. People picker field value is not captured in Excel sheet.
    2. No datetime field is captured in Excel sheet.
     
     
    Any way to get those values in excel like other field.
     
     
    Thanks
    AJAY
  • David_MA Profile Picture
    10,874 Super User 2025 Season 1 on 08 Apr 2025 at 18:55:48
    Export SharePoint list to Excel sheet.
    Take a look at this as it may assist in what you want to do: Get Over 5000 Items From A SharePoint List In Power Automate. Since you don't show your flow, I don't know what you've done. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 109

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 90 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 62 Super User 2025 Season 1

Overall leaderboard
Loading started