News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Export SharePoint list...

Power Automate - Building Flows

Unanswered

Export SharePoint list to Excel sheet.

Like (0) Share

Report

Report

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

All responses Img

All responses (2)

Answers Img

Answers (0)

CU08041330-0 2 on 09 Apr 2025 at 07:19:29

Like (0)

Report

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 10,874 Super User 2025 Season 1 on 08 Apr 2025 at 18:55:48

Like (1)

Report

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

May 14th | Power Platform Community AMA: Power Apps Edition

Quick Links

Leaderboard > Power Automate - Building Flows

#1

stampcoin 109

#2

Michael E. Gernaey 90 Super User 2025 Season 1

#3

David_MA 62 Super User 2025 Season 1

Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans