cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
igel2187
Level: Powered On

Can not detect blank value in ms.flow

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"

 


Accepted Solutions
Highlighted
igel2187
Level: Powered On

Re: Can not detect blank value in ms.flow

 

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

 

01-31-18 7-48-04 AM.png

 


All Replies
Community Support Team Rank
Community Support Team

Re: Can not detect blank value in ms.flow

Hi @igel2187,

 

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:7.JPG

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

 

The flow works successfully as below:8.JPG

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/t...

 

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

igel2187
Level: Powered On

Re: Can not detect blank value in ms.flow

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

 

 

 

anhthuch4ng
Level 8

Re: Can not detect blank value in ms.flow

Hi @igel2187,

 

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. Smiley Happy

 

Looking forward to learning more,

-AT (Community Admin)

Highlighted
igel2187
Level: Powered On

Re: Can not detect blank value in ms.flow

 

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

 

01-31-18 7-48-04 AM.png

 

>