You’re offline. This is a read only version of the page.
I have a flow that has been running live for weeks and not changed. I connects to two Excel sheet with 3 tables in each. Today I find that the table names have been shuffled between actions causing a total mess. I must stress that absolutely no changes have been made to the flow or the spreadsheet table formats. How can flow do this and how can I avoid it?
Hi,
I encountered the same problem.
This link might be helpfull.
If you manually adjust the excel files, the table names will shuffle.
https://powerusers.microsoft.com/t5/General-Power-Automate/MS-Flow-Lost-Table-Names/td-p/295643
Not a solution. Followed your suggestion and now worse. What a waste of time.
As you can see below, the table name, which should be 'Receipts' has been changed. Messed up table names in all Excel steps. Multiple spreadsheets now, one table per spreadsheet.
Hi @stevejs ,
Your issue couldn't be confirmed so you could take a try with the way that wouldn't has the issue.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @stevejs ,
I suggest that you could create new excel with the three tables, and create a new flow to see if the issue still exists.
If the issue still exits, I suggest that you should create the tables in different excel files, each file would have one table in it.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The first few steps:
The corrupted step (one of many):
The sheet has 3 tables; Date, Orders, Receipts. In the above step the table changed from Date to Receipts.
This step has never been edited since creation.
In all steps referencing the Date table were changed to Receipts. All steps referencing the Receipts table were changed to Date.
Hi @stevejs ,
Could you please share a screenshot of the configuration of your flow?
Could you please explain more details about the issue? does the flow change the excel table name when runs?
I have made a test and there is no action could update the table name in Microsoft flow currently.
Please make sure that you choose the table name from the drop down list when use excel actions.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What is the location your Excel spread sheet? If they are located in SharePoint Document library or One Drive, check the Version History to isolate when the table names were changed.
Also, you can check the flow execution results to see if it made any such changes.
Regards
Krishna
Note: If my reply helps to resolve the issue, please mark the reply as Accept Solution. This will help other users to identify it as solution for the issue.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (