I am having trouble getting data from an excel document into a SharePoint list and am receiving this error on my workflow:
The workflow seems to work as far as creating the file in a SharePoint document library however fails on the list rows present in table action. As ideally I want to copy data from the rows into a SharePoint list - any pointers on getting this working would be awesome! Thanks 🙂
Http request failed: the content was not a valid JSON.
This is my flow:
The next step, parses JSON from the File attachment item in the Microsoft Forms form.
So if you are getting the file from the response details it is not giving u the direct url so you need to get the url part only of the file without the name part.
Try passing the link for example from parse json output.
Yeah, sorry just corrected my flow to look at the file created in SharePoint and now the excel row action is presenting this error:
No table was found with the name 'Table1'.
I can see the table name is there in the document so I'm not sure why it says it cant find it?
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!