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"

 

1 ACCEPTED SOLUTION

Accepted Solutions
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

 

View solution in original post

4 REPLIES 4
Highlighted
Community Support Team
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

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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. 🙂

 

Looking forward to learning more,

-AT (Community Admin)

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

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,254)