Microsoft Power Automate - How to do REST API Calls and update Excel - Full Tutorial

This video tutorial shows how to make REST API calls in Microsoft Power Automate and update an Excel sheet with the information requested from the http. JSON parsing is also covered.

You could also watch:
🔵 Power Automate for Beginners - https://youtu.be/omQ-fAF4QpI
🔵 Power Automate & WinAutomation Setup - https://youtu.be/YbAAxnrTSBo
🔵 Regex in Power Automate - https://youtu.be/9abd1uL7tHo

0:21 Inspecting our Excel data
Our data is currency rates in an Excel sheet (OneDrive) and we want to constantly get the newest rates into our sheet. A simple REST API (HTTP request) solution will be applied.

0:56 JSON with our data
We inspect the updated currency rates, which is in JSON format.

1:47 Create a new Power Automate Flow
Usually we want to schedule these flows, but for a simple example, we will create an instant flow.

2:20 HTTP
Chose a HTTP action. The method is GET here (it is not always, so be aware of what settings your API require). Further more we specify the URL (endpoint).

3:02 Parse JSON
Under Data Operations chose Parse JSON. The content is the body from our HTTP request. The schema we create in an easy way.

4:14 Update Excel
With the newest data from the REST API call, we can now update our Excel sheet in OneDrive.

Connect with me:
📷 Instagram - https://www.instagram.com/andersjensenorg
👱‍♂️ Facebook - https://www.facebook.com/andersjensenorg
🎮 Discord - https://discord.gg/d8KQpTUvFD
💼 LinkedIn - https://www.linkedin.com/in/andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsletter
🕊️ Twitter - https://twitter.com/andersjensenorg

#powerautomate #api #excel

Видео Microsoft Power Automate - How to do REST API Calls and update Excel - Full Tutorial канала Anders Jensen