Working with Do Until Loop in Power Automate with JSON and Array


The article discusses how to use the Do Until loop in Power Automate to run a loop for a specific condition met. The scenario involves building a flow that gets a JSON response from a third-party web API request called Currency Layer to get live exchange rates and push the response in Dataverse table using a loop. The solution involves designing a table and flow, initializing a string variable, setting the value as Target currency, initializing an array variable, setting the value to store the currencies with comma splitting for the Target Currency Variable, adding an HTTP action to connect the web API with URI, adding a Parse JSON step to extract properties from the HTTP response JSON, and adding a Do Until Loop action.


Article 18m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time