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 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.
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.
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?
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!