Unanswered

Add a row into table - No table was found - new issue in till now working flow (!)

(0) Share

Report

Posted on by HH-24070835-0

Hi,

I have this flow that has been working fine no issues until like 4 days ago when it started failing. The flow reads values from the source and updates an excel table using Add a row into table (File A, Table1). After that it creates a copy of the original file (File A) with adding the date in the file name (year-month-day File A) and then it replaces the content of the original file (which is at this moment populated with the data) with a file with an empty table (File B copy to File A).

After every time the flow runs the link to the File A Table1 breaks and the next run is with the error message: No table was found with the name '{609F9445-75CD-4D5E-8351-3328E373BF5B}'.

In order to make the flow run every time prior the flow runs I have to go to Edit flow, Add a row into table step and manually correct the File and Table selection.

1) is it some kind of a bug behavior and should be corrected by MS team? because it just started happening few days ago. if yes, how can I escalate this?

2) is there any workaround solution that I could use?

please help

Screenshot 2022-03-14 093752.png

Screenshot 2022-03-14 093330.png

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @ennika click on the X icon near to that code and select the table if the table don't exist on your excel you need to create a table

Was this reply helpful? Yes No
HH-24070835-0 21 on at

Like (0)

Report

This is something I am currently forced to do - this kind of correction - every and each time and day the flow runs. Go and edit the flow and select the same file and table again and again. The information about the table just disappears from the flow after it runs. As it run absolutely smoothy before (more than a month of flawless runs), and started happening only few days ago I believe this is some kind of a bug in PA that should be addressed and solved by someone from the MS team.

Was this reply helpful? Yes No
Verified answer

Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (1)

Report

Hi @ennika ,

This is not a big issue, even most of the times am also facing same issue.

This issue occurs because sometimes you may created new column or by mistakes deleted file and reuploaded.

Just go to code

delete action add a row into a table

Add again same action add a row into a table

and add everything what you added previously.

Save and again test it will work.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report

You used dynamic content to fetch the file/table, which means its static.

You can correct this by first collecting the file ID and table ID based on filters, store them in a variable and use that in the 'add row' action.

This way you make the input for selecting the table dynamic. This is important, since in your flow you make a new table, which has a different ID than the previous one, causing the error you described

Was this reply helpful? Yes No
HH-24070835-0 21 on at

Like (1)

Report

thanks, I will definitely try this and let you know!

Was this reply helpful? Yes No
HH-24070835-0 21 on at

Like (0)

Report

unfortunatelly it did not help. The flow runs successfuly once, all the next runs fail unless I change it manually in Edit again (to the same file & same table). It seems that something changed in the background, maybe in the "Add a row into a table" functionality that it is not reading anymore the name of the file & table (eg Table 1) but it is searching for the address of the table {609F9445-75CD-4D5E-8351-3328E373BF5B} in this step. Actually it seems that it cannot find the file (not finding the table is just the consequence).
So it still remains unsolved 😕

Was this reply helpful? Yes No
Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (0)

Report

I need to ask one thing, here you are working on single excel or different excel each time

Was this reply helpful? Yes No
HH-24070835-0 21 on at

Like (0)

Report

It is the same file but replaced content. Maybe this follow-up steps will explain:
It is file A which the PA flow populates with the new rows and then it copies file B (with an empty table) to file A in order to get it ready for the next day run (with a bit of workaround through Create file in different location and then Move it with Replace parameter).

I started thinking about keeping all the previous data (maybe with utcnow value in additional column so I can distinguish by date) so i would avoid necessity to delete the previous data.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report

You are creating a copy of the file, that means it has a different id

If you manually look for the file for the add row action, you make the id static, causing it to fail

The only way to fix this is to look for the file first using filters, store the id in a variable. Use the stored id to look for the table in the file, then store the id of the table in another variable. Use those two variables in the add row action, rather than the static id's you are manually using now

Was this reply helpful? Yes No
HH-24070835-0 21 on at

Like (0)

Report

Thanks for you reply. Yes, that sounds reasonable, however this flow has already been succesfully working for more than a month - with the same logic and stopped only recently.
In case I create variable (not experience yet, I can learn) will I get the rows in the Add rows into a table step? Will they appear? Or how will I assign values to the table columns?

now I am starting to think it could be some change in sharepoint settings (which I cannot influence), maybe I could try it with file stored in onedrive.

Was this reply helpful? Yes No