Unanswered

Using any data in a column to show as 'True' and if it is blank, show as 'False'

(0) Share

Report

Posted on by LindsayEaston89

Hi,

I have created a flow which is to send email reminders periodically UNTIL a reply has been received. However, because we also want to see the date of reply and not just that it has been received , we want the column to be a Date column, rather than a Yes/No. But the only way I can find to trigger the condition 'Do Until' or 'Condition Column Name is equal to True' is by using a Yes/No column. This means I have an unnecessary column which requires additional input just to be able to stop the email reminders once the reply is received.
Is there any way at all to make Power Automate recognise that any data in a column = True and, if the column is left blank = False so I can get rid of the unneeded Yes/No column?

Thank you

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!
If you switch to advanced mode, you can type an expression instead of picking fields.

There you could enter

@not(empty(<reference to your field>))

Was this reply helpful? Yes No
S-Venkadesh 1,214 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @LindsayEaston89

You can utilize the following expression within the trigger condition to verify the null value of any column:

@equals(triggerBody()?['DueDate'], null)

I've added a screenshot demonstrating the use of a date column for testing purposes.

I hope this information is helpful. If it is, please consider giving a thumbs up 👍.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No