For each row, do an HTTP Request and update the row with the results from the response
Perform error handling if an ID doesn't exist at the API
Hints
HTTP Request
Parse JSON
Apply to each
For the Excel
List rows present in a table
Update a row
Error-handling
Use a switch on the Status code
Video Guide
Comments (2)
These comments were migrated from the previous version of this site. Commenting is closed.
Krishnan V
Hi, thank you for the video. It has been very useful. However for the past two days the API address is not working.
Stine Høiberg Rasmussen
Thanks for writing 😊 We’re getting more than 50 messages daily. While we read all of them, we can’t reply to everyone 😔 But we’ve created an RPA/Automation community where we’re 14,000+ RPA Developers helping each other with solutions and our careers. It’s free, and you can find it here: https://discord.gg/iloveautomation Kind regards, Stine
More tutorials
Microsoft Power Automate
Lessons for Microsoft Power Automate (cloud): approval flows, Excel, Outlook, forms, AI Builder, HTTP requests, error handling, and more.
We need to know a little "code" when working with Excel in Power Automate: WDL (Workflow Definition Language) to create functions JSON to interpret the results
