Using Filter Array, Loops, Variables and SetProperty Scenario in Power Automate


The article discusses how to use filter array, loops, variables, and SetProperty scenario in Power Automate. The scenario involves sending a consolidated table email containing unique doctors and total patient count. The solution involves defining a trigger, getting all records from Dataverse target table, defining variables to manage string and array, initializing JSON variable, and using a loop to iterate through all records present in the list retrieved in step 2. If the doctor name variable does not contain records doctor name, the loop goes to the YES branch, and if it is an existing doctor, it goes to the NO branch. The article provides detailed steps and screenshots for each step.


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