Unanswered

RE; Help Needed with Flow

(0) Share

Report

Posted on by cmcmullan

Hi guys

I am hoping somebody could help me.... I am trying to build a flow to assist with an ongoing monthly process that requires us to seek information from our client via an MS Form. Responses will then automatically be logged on our spreadsheet. What I am hoping to do is, at the end of each month, to automatically send a reminder to clients that have not completed the form. This is where I am coming unstuck.

My flow so far is attached.

I am fairly sure that everything between 'delay until' and 'send an email' is a bit of a mess, and honestly, I'm not sure what isn't working, but after testing it, I am not receiving any emails to remind me to complete the form.....

Any insights or help would be massively appreciated, so thanks in advance!

Ciarán

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @cmcmullan

May i know what you are trying using delay until and get tables and the condition part ?

Was this reply helpful? Yes No
cmcmullan 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

Thank you for responding! My plan was to pause the flow until a specific date and time, using the 'delay until' function, and then I want it to check my spreadsheet, specifically two columns, and for rows where they are empty, I would like for an email to be sent.

Please let me know if you need more clarity on this. Thanks again for your help.

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Also could you share the condition, I hope that is the part where you are facing issue ?

Was this reply helpful? Yes No
cmcmullan 12 on at

Like (0)

Report
Copy link

Link copied!

Sure

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Ok @cmcmullan

But why are you comparing there , are they 2 columns ?
Is it the output from get tables action ?

Was this reply helpful? Yes No
cmcmullan 12 on at

Like (0)

Report
Copy link

Link copied!

Yes, they are two different columns, and I want the email to be sent if either of them is blank.

I have put the 'get tables' action after 'delay until' so that the flow can check which rows have a blank cell in the columns specified in the condition. The hope is that once these rows are identified, then the email will follow.

I am unsure if the 'get tables' action is even needed.

Was this reply helpful? Yes No
cmcmullan 12 on at

Like (0)

Report
Copy link

Link copied!

On a basic level, this is what I am trying to achieve

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes you don't need to use get tables as its function is to retrive table list present in worksheet.

Instead of that use list rows action

then use filter query to check the columns are null or not

expression: and(equals(item()?['A'], null),equals(item()?['B'], null))

replace A and B (highlighted) with the column name

Next use length in condition to check the output of filter array is zero or not

if the length is not equal to zero, it mean there is null values and you have to send email 🙂

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes you don't need to use get tables as its function is to retrive table list present in worksheet.

Instead of list rows action

then use filter query to check the columns are null or not

expression: and(equals(item()?['A'], null),equals(item()?['B'], null))

replace A and B (highlighted) with the column name

Next use length in condition to check the output of filter array is zero or not

if the length is not equal to zero, it mean there is null values and you have to send email 🙂

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @cmcmullan

Regarding this part of flow

Do you have any specific reason to keep flow like that till end of month?

If not, could you try a scheduled flow to run every month end to check whether the data is empty or not and sent a reminder, that would be better instead of keeping flow pausing for a long time 🙂

Was this reply helpful? Yes No