Question
You need to configure a Power Automate flow to send the email with the results to the client.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Trigger settings: Set Table name to Qualification and Column filter to statuscode. The flow uses the Dataverse trigger When a row is added, modified or deleted on the Qualification table, because a service request can only be completed after its qualifications are finished, so a change to a qualification is the event to react to. The column filter is statuscode (Status Reason), which holds detailed values such as Pending Verification and Complete; statecode only holds the broad Active/Inactive state, and triggering on Service Requests would not fire when a qualification changes.
Logic to complete service requests: Loop through related qualification records and complete if all are in Complete status. One service request can have several qualifications, so a single qualification being Complete is not enough, and Pending Verification means work is not finished. The flow lists the qualifications related to the parent service request, checks each status reason, and completes the service request only when every one of them is Complete.
