Sharepoint List to Excel Table

(1) Share

Report

Posted on by ST-18091314-0

Hello,

New to Power Automate and am trying to essentially pull down all the data from a Sharepoint List and add that data to an Excel file table in the Sharepoint. Eventually this file would be emailed to users.

I'm having a very hard time getting the rows to add properly in the existing table. The data populates but when it adds it looks like it's all headers formatting. Any ideas?

Steps I have

1. Get File Data - pulling from the Sharepoint

2. Select - from get data

3. Initialize variable - "Vararray

4. Set variable - based on "output" from select function (#2)

5. For each (varArray)

5A. Add a Row into Table

Categories:

General topics

PowerAutomateOutp...

PowerAutomateFlow...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Why do you say, get file data? Do you mean Get Items? as they are 2 different things so I assume you are getting items, not getting file data

Why are you shoving stuff in an array and then looping, just loop through the Select output

Sorry I do not understand this comment

"I'm having a very hard time getting the rows to add properly in the existing table. The data populates but when it adds it looks like it's all headers formatting. Any ideas?"

What do you mean? It looks like Id's just fine and dates just fine? Can you Change some of the data so you dont have to hide it so I can see what you mean please.

I mean your code looks just fine (needs error handling before i'd approve it for production) but it looks just fine.

Why even do a Select? why not just look through and use the Add data, and assign each row.

Was this reply helpful? Yes No
Suggested answer

AnnaAutomates 2 on at

Like (0)

Report

Hi,

I may be misunderstanding, but I think there could be a simpler way of getting your SharePoint list information into Excel.

Example SharePoint List:

Use Get Items and Add rows to table. Specify the table and then map the SharePoint Columns to the Excel Table columns:

Output into Excel:

Was this reply helpful? Yes No