Exporting SharePoint List into new Excel table with headers

Like (0) Share

Report

Posted on 28 Jul 2023 23:44:32 by jmallozzi

Hi,

Im having trouble with adding rows to the new Excel table. It will either fail or timeout. I also cant add multiple filter queries with and /or commands it fails every time. Any suggestions?

All responses (6)

Answers (0)

takolota1 4,863 Super User 2025 Season 1 on 30 Jul 2023 at 18:53:36

Like (0)

Report

Re: Exporting SharePoint List into new Excel table with headers

@jmallozzi

Are you sure you want to create a new Excel table for each record in your dataset?

You may want to take that outside the Apply to each loop if you only want one table.

Also it looks like you are naming the table “data” but then you are trying to use the values from the SharePoint “Name” column as the table name to send records to. You will want that Add a row action to use the table name that you created earlier in the flow, not a value from SharePoint.
jmallozzi 7 on 30 Jul 2023 at 18:40:06

Like (0)

Report

Re: Exporting SharePoint List into new Excel table with headers

@takolota that was very helpful and you were totally right. However, the flow simply isnt communicating with excel to export the data. The flow is working to create a new file > creating a table > adding headers but not adding the data to the rows. Im super new to Power Automate so Im sure it's user error, but I dont know what to do to fix it.

This is the message
takolota1 4,863 Super User 2025 Season 1 on 30 Jul 2023 at 01:49:45

Like (2)

Report

Re: Exporting SharePoint List into new Excel table with headers

Also @jmallozzi are you sure “Fiscal Year” is the true SharePoint column name for this? Sometimes special characters will cause issues, so you may want to go to the list in SharePoint, go to List settings under the gear icon, go to the column name to bring up the column page, then go to the end of the url for the column page to find the back-end SharePoint column name & not just the display name.
trice602 13,768 Super User 2025 Season 1 on 29 Jul 2023 at 16:57:24

Like (0)

Report

Re: Exporting SharePoint List into new Excel table with headers

Is fiscal year a number, string, or date column? Seems to be the issue. Always glad to help! Tom
jmallozzi 7 on 29 Jul 2023 at 16:49:18

Like (1)

Report

Re: Exporting SharePoint List into new Excel table with headers

Thanks for the response @trice602 !

So I added the delay, however the flow keeps timing out as it attemps to "apply to each."

I attempted to add additional filter query to help limit the data being exported, but I get an error every time.
trice602 13,768 Super User 2025 Season 1 on 29 Jul 2023 at 01:24:01

Like (0)

Report

Re: Exporting SharePoint List into new Excel table with headers

Hi @jmallozzi ,

Looks like you have done a good job here. Have you tried adding a delay in-between the create file and create table? I've had similar problems and if my memory serves me correctly a delay helped. Please let me know - always glad to help! Tom

Also please post the screen clip of the error message.