cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevewiddowson
New Member

Excel tables keep changing in Flow UPDATE and GET row Steps

Hi guys,

I'm having a very weird error that keeps recurring. I have several flows setup that GET and UPDATE rows in several tables within the same XLSX workbook when Forms are submitted. However, I have noticed that Flows, seemingly of their own accord, begin failing. When I view the failed run, the reference tables I have stipulated in the Flow has completely changed to a different table in the same file. Each Flow consistently changes the table from the one I've specified to the same incorrect one. The XLSX is editable and is accessed frequently via Excel Desktop and Online as it contains recruitment data that we run mail merges from and sometimes needs editing.

This is incredibly annoying, and has resulted in corrupt data in some cases due to similar field names causing a Flow to successfully update the wrong table. Has anyone else experienced anything similar?

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @stevewiddowson ,

 

As far as I know, the actions contained in MS Flow do not actively change the records in other unconfigured tables.

 

The configured Flow will only execute and complete data operations according to the configured parameters and conditions.

 

And when configuring the action in the Excel connector, we must select the Excel file and table that have been defined. These parameters cannot be dynamically configured, so the table is fixed.

 

Please share your Flow configuration with us, we could try to reproduce similar issues in order to find the cause of the error.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

I think I worked out what was causing the problem in my case. My flow was updating rows in multiple tables in a single workbook - once I split each table out into a separate workbook I have not had the problem recur. Terrible solution to a really annoying bug, but it worked for me. Not sure of your exact setup, but if you have anything similar to that, try splitting tables into separate workbooks and running the flows again.

View solution in original post

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

Hi @stevewiddowson ,

 

As far as I know, the actions contained in MS Flow do not actively change the records in other unconfigured tables.

 

The configured Flow will only execute and complete data operations according to the configured parameters and conditions.

 

And when configuring the action in the Excel connector, we must select the Excel file and table that have been defined. These parameters cannot be dynamically configured, so the table is fixed.

 

Please share your Flow configuration with us, we could try to reproduce similar issues in order to find the cause of the error.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I'm having a similar issue.  The table name is not fixed it is changing by itself between runs. 

 

I set a table name as "Table1", ran my flow once and it worked as expected. 

When I tried to run my flow again I received the following error. 
No table was found with the name '{E5853258-8B64-4462-AB0C-A3E20225A269}'.
clientRequestId: 138b4399-c238-45e4-ad81-392966f40e92
serviceRequestId: 41586a4c-0adc-4e59-b650-60373138f895

I think I worked out what was causing the problem in my case. My flow was updating rows in multiple tables in a single workbook - once I split each table out into a separate workbook I have not had the problem recur. Terrible solution to a really annoying bug, but it worked for me. Not sure of your exact setup, but if you have anything similar to that, try splitting tables into separate workbooks and running the flows again.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,889)