Unanswered

Exporting SharePoint List into new Excel table with headers

(0) Share

Report

Posted on 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?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jmallozzi 7 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Is fiscal year a number, string, or date column? Seems to be the issue. Always glad to help! Tom

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (2)

Report

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.

Was this reply helpful? Yes No
jmallozzi 7 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@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.

Was this reply helpful? Yes No