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.
Login now to access my digest by 365.Training