Can not detect blank value in ms.flow

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Anyone,

How can I add a condition to check if a field has a blank value?

I use @empty(triggerBody()?['Choose_x0020_Approval'])

Even I have value on it, it keep detect I have blank value, so approval flow keep coming.

What to expect is if value not blank, approval will run

Note: my column name is "Choose Approval' somehow, of its autogenerate become "Choose_x0020_Approval"

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous,

Which data type is the Choose Approval column in your SharePoint list?

I think the formula that you provided within Condition box is correct. The empty() function would return false if there is a value in Choose Approval column, so the flow would go into "If/no" branch of Condition. If there is no value in Choose Approval column, the empty() function would return yes, the flow would go into "If/yes" branch of Condition.

I have made a test on my side and the flow works well. My flow's configuration as below:

Note: The Choose Approval column is a Single line of text type column in my SharePoint list.

The flow works successfully as below:

I think you have a misunderstanding in the usage of empty() function, the flow that you provided is correct and could achieve your needs. Please check and see if the following article would help you understand the usage of empty() function:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Knowledge-Base/How-to-check-if-a-field-is-blank/ta-p/31843/jump-to/first-unread-message

More details about the empty() function in expression of Microsoft Flow, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#functions

Best regards,

Kris

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

Like
a
(1)

Report
Copy link

Link copied!

hi @v-xida-msft,

Type is person.
Is there any difference of using formula for different type of data?
I just found out that using different features also works (without use formula)
1. condition is equal to "I leave blank in the field"
2. condition is equal to "use expression > logical function > null"

but I found the root cause, it's not because of the formula.
because I use other trigger to update item in share point in the next step.
So, I just need to define other condition to prevent that.

thanks so much

Was this reply helpful? Yes No
anhthuch4ng Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Thanks for posting to the Flow Forum!

Would you mind sharing a breakdown of how you determined the root cause of your initial Flow issue?

That way other community members who might have similar issues may follow your steps to troubleshoot. 🙂

Looking forward to learning more,

-AT (Community Admin)

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @anhthuch4ng,

to check whats is the issue from ms flow, we can check from flow history.
Just see in which brach the error icon / running icon is showing.
after that, just click and see the "output > body message", error message is shown like this: "message": "The passed-in field \"Submitted\" could not be found\r\nclientRequestId: 9ff2e1f6-c2b8-4fcb-8402-00ab81feae8f",
we can identify from that

thanks

Was this reply helpful? Yes No