Unanswered

Check if multiple SharePoint fields are not blank

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to add a condition where an action will only execute when three fields are not blank. I thought the following code would work but it evaluates as "TRUE" when I there is clearly values in all of the relevant fields.

@and(not(empty(triggerBody()?['Approver_1 Email'])), not(empty(triggerBody()?['Approver_2 Email'])), not(empty(triggerBody()?['Approver_3 Email'])))

Any help would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @obi735,

Could you please share a screenshot of your flow’s configuration?

Do you want your formula to be evaluated as false when all relevant fields are filled with clear values?

Further, could you please show a bit more about these relevant fields? Are they Person or group type column?

If these relevant fields are not Person or group type columns and you want to check if all relevant fields are not empty with the formula, I think there is something wrong with your formula, please take a try to modify it into following formula:

@and(not(empty(triggerBody()?['Approver_1_x0020_Email'])), not(empty(triggerBody()?['Approver_2_x0020_Email'])), not(empty(triggerBody()?['Approver_3_x0020_Email'])))

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kris,

Thanks for the reply. I failed to mention that I had already tired the version of the formula you suggested... same result, it evaluates as false all of the time. Here are the answers to your questions, perhaps we can figure this out.

This formula is triggered anytime an item is changed in a list. After I resolve this condition it will send a few emails. Ideally I want the formula to evaluate as True when all three fields (each one is a "single line of text") are not blank. Here are some screenshots of the list settings and what was passed into the formula. In this case all three relevant fields (Approver_1 Email, Approver_2 Email, and Approver_3 Email) were not blank but the formula still evaluated as false.

Here are the columns in the list:

Here is the flow:

Was this reply helpful? Yes No