cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abhinavthakur
Regular Visitor

MS Flow Lost Table Names

I have a few scheduled and automatic flows setup which are run from an excel sheet on a Teams group. The excel sheet is auto-updating for each month so every month, dates automatically update from say May to June and so on for monthly tasks. At the beginning of the month a couple of my scheduled flows failed and when I checked all of my flows had the table names changed to something which looked like this - {ED2A5438-27D3-4D3C-9800-8A6B5FCECAF7} and key column to _x0023_  There was no table with that name so the flows failed. I am thinking this has something to do with dates changing but I don't understand why the table name reference in flow would change even though the table names in the source excel sheet didn't. I was able to go into each flow and relink the tables without issues. My question is, do I have to do this every month or am I missing an easy solution here?ms flow question.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hey @abhinavthakur  The long string that you are seeing is the ID of the table. As long as you are not adding any extra "columns" to the table and changing the workseheets manually, you should not have this issue. If you change the columns (names/ number/ add/ delete/ type etc) you might see such errors. 

 

Hope this Helps!

View solution in original post

1 REPLY 1
yashag2255
Dual Super User II
Dual Super User II

Hey @abhinavthakur  The long string that you are seeing is the ID of the table. As long as you are not adding any extra "columns" to the table and changing the workseheets manually, you should not have this issue. If you change the columns (names/ number/ add/ delete/ type etc) you might see such errors. 

 

Hope this Helps!

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (37,744)