Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id : HpePD7bb9zOk9lT6rbSNB8
Power Platform Community / Forums / Power Automate - Building Flows / Export SharePoint list...
Power Automate - Building Flows
Unanswered

Export SharePoint list to Excel sheet.

Like (0) ShareShare
ReportReport
Posted on 8 Apr 2025 13:36:01 by CU08041330-0 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
Categories:
Business Process Flows
VBScript.txt
  • CU08041330-0 Profile Picture
    CU08041330-0 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
    David_MA 11,217 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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 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…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 385 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 330

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 328 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans