Good day,
I am building a flow to have MS Form responses collected in an excel sheet. Once collected on the excel sheet, the sheet is formated to score the response and give an overall score. I would like for all the rows which has passed the quiz to populate onto the sharepoint list. The problem that i am having is that once the flow updates the sharepoint list, it updates the failed rows as well thus i have all rows added to the sharepoint list.
Is there anyway to filter the rows populated in the list rows present in table or get items to include a criteria for selected rows to be populated in the sharepoint list based on a score?
My main goal is after a MS Form Quiz have been completed i would like a certificate generated and emailed to the persons for those who pass and an email generated and sent for those who failed. I have got to the point of setting the pass criteria and sending the email for those who failed.
See flow built thus far.
Appreciate the help.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
137 | |
44 | |
32 | |
32 | |
29 |