Unanswered

Flow is incorrectly reading the status of blank fields in a condition statement

(0) Share

Report

Posted on by SPAccount

Kind of frustrated on this one. I basically have a condition that says if a field is not blank AND two other fields are not blank to execute. The fact is that despite some of the fields being blank it is still executing. In my screenshot below you can see the three fields that I am referring to (Employee Number, Employee e-mail, and Payroll Provided Username) in the condition. You can also see where some of these fields are blank in the SharePoint list. Yet when I run the flow it comes back as true when it most certainly isn't true.

You can also see where I tried doing "Null" as the value but that didn't help. Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I suspect that your issue is that there is a difference between Null and Blank. An Empty string "" is blank, but not Null. Try using empty() inthe formula expression of the dynamic content instead of Null.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

Currently it's looking for the string "null". Instead use the expression null.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
SPAccount 20 on at

Like (0)

Report

@Pstork1Unfortunately this didn't work for me, and give me a lengthy error when I ran the flow.
@RobElliottThis worked perfect!!! Thanks!

Was this reply helpful? Yes No