Re: GetFiles(properties only) returns Bad Request errors
Hey @Anonymous
You mentioned working with lists and I see the get files action. Can you share more details on the scenario that you are trying to build? Are you working on the sharepoint list items or sharepoint document library?
Next I can see that you are creating this worksheet and creating a table. Note that the create worksheet action will create a new worksheet for you but then the create a table action will simply create the table on the base worksheet and not the newly created worksheet. If there is already a table on the base worksheet with the same range/ overlapping range the flow will error out saying that overlab is not possible.
Finally in the create a table action, you put the dynamic content, this will basically create the columns with the headers as the dynamic content from the sharepoint action. Note that the apply to each loop and the current flow will simply keep creating worksheets and tables only (not a single worksheet and table with all the data).
TO populate a table in excel sheet from flow, you need the excel sheet and the table properly formatted on the escel sheet on the document library.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
