Automated Email Not Stopping When There Is A Match Between Reponses of Two Microsoft Forms

(0) Share

Report

Posted on by CU19112313-0

I am working on Absence Reporting and want to send a reminder email to the responder of a Sickness Absence Form to remind them to complete a Return to Work Form after 7 days and keep sending the form every 7 days until it is completed.

I am using Response ID from the Sickness Absence Form and then have a question in the Return to Work Form for the responder to input the Response ID from the Sickness Absence Form to be the common identifier between the two forms. The Return to Work Responses are already to a SharePoint list using a different flow.

It sends the email fine, however it doesn't stop sending the email when the Response ID in the Return to Work List matches the Original Response ID.

The top half of the flow is New Response Submitted Trigger>Get Response Details>Condition which checks if the sickness reason entered matches a reason we send a reminder for (this all appears to work fine)

I attach pictures of:

Bottom Half of the Flow (which seems to run without error)

Get Items Query

Condition Query (the Do Until Loop Query is the same as this)

Any help would be much appreciated

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

abc 123 789 Moderator on at

Like (1)

Report
Copy link

Link copied!

Length(Body/Value) is probably not returning a zero. Maybe it's null.

One way to solve would be to set a Boolean variable to False, then do the Get Items. Add an Apply to Each action, and inside it, set the Boolean to True, meaning something was found. If nothing is found then the Boolean variable remains false.

After the Apply to Each, then you can react to the value of the Boolean Variable. Just know that you'll need to use the Config Run After setting, such that the first Action after the Apply To Each will trigger, whether the Apply to Each executes or gets skipped.

Was this reply helpful? Yes No
MiDer 139 on at

Like (0)

Report
Copy link

Link copied!

If the Sharepoint get items action does not give you anything in return, you should be fine checking against length() of the body/value.
Have you looked at the get items output from a Flow run as well, to ensure it is not the oData query rather than the condition?

I could imagine folks are using copy `n` paste with leading or trailing blanks or simply type case-insensitiv.

Was this reply helpful? Yes No
CU19112313-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks abc 123 that solves it

Was this reply helpful? Yes No