How to list table that get's updated to share point list

[Sahara22]

Hello, 

I have been searching for hours and I can't find a solution. I have an excel sheet that it's updated automaticaly then writes to a Sharepoint list. The problem is when it updates I get the error in my flow "No table found" because it's a different Id. 

I tried get table method/ as table put Id.. but when my next action to "get items" to copy to Sharepoint list , my tables columns won't show up...

Here's a picture of my flow.. any idea's? 

[Sahara22]

Any idea's? anyway to get around the "No table error" because the excel sheet updates?

[RobElliott]

@Sahara22 I have a similar situation with a spreadsheet that gets updated weekly. Unfortunately even as a super user I have never found a solution to the table not being retained and therefore the flow fails. I have to update the spreadsheet (to add the table) and update the flow each week. Hopefully someone might be able to come up with a solution.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Sahara22]

Hello @RobElliott , thanks for the reply back. How about if you list the items dynamically, i read this somewhere but not sure how would I write this.. "Item(0?['Column name'] " would that work? 

[Sahara22]

After searching and trying over and over again, I managed to fix the  "table error"  part but now when items are writing in the Sharepoint list, its just writing the first entry over and over again... any ideas? 

Please see picture below.