In my flow I am getting data from excel using HTTP get method which is working fine but I am not sure how to load those rows into share point list. Here is my flow. Any help would be really appreciated!
Hi @Gopi2212, is there any particular reason you are using the Get method and the wanting to use an HTTP request to add the rows to the SharePoint list? I ask because I would do it a much simpler way by adding an Excel Online (Business) List rows present in a table action and add a SharePoint Create Item action which will wrap itself in an Apply to each control. That means that an item will be created for every row it finds in the Excel table.
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.
My excel location will be dynamic. I believe that get rows in excel business will work for static location. In my case, multiple users will upload multiple excel into share point library.. whenever there is an excel it should get the rows and post into SP list.
Can you trigger the flow to start when a new xls is added to the library? Then, you would have the name of the file that was added, store it in a variable and you could use @RobElliott 's solution
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications