cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 @Anonymous  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 @Anonymous  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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,686)