Automating Survey123 Report Emails through Power Automate when paid

[RoadAndBridgeGISAdmin]

My flow will create a report, upload it through my OneDrive, then email whoever is listed under the "Send an email" step but I need to add a new step. I want the report to email to the person AFTER it has been paid for, with my flow it would automatically send through if its been paid for you not. They usually aren't paid for when the report get submitted so I need another step that'll trigger the flow when it's paid for.

[CodyPatterson]

Hey @RoadAndBridgeGISAdmin 

From your picture, it appears at a surface level that it's checking if the body of your Survey123 results = the body of your Survey123 results which will always result in true and sending the email.

You will probably have to place a Compose cell in, which you would then break down the paid/not paid value within the Survey123 output by selecting the corresponding value from the dynamic attributes list. Once the result is found, it can then be compared using the comparison and will read your value.

Hope that helps!

Cody

[RoadAndBridgeGISAdmin]

If I put the Compose cell in under "Create report", it doesn't pop up with the fields in the survey for example "Date Paid". It shows jobId, Status, title, queryParameters, etc. under the Inputs that can be put in. 

[CodyPatterson]

Hey @RoadAndBridgeGISAdmin 

When you placed a Compose cell under the Create Report section, did it end up containing itself in a For Each loop? If not, you may want to create one in this format here:

Where body/value is the Survey123 body/value, and the Compose within the For each, that may get you moving.

Let me know otherwise!

Cody