cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Check for empty cells in Excel

Hi,

 

I am trying to create a flow to check for empty values in a column called 'Date Checked'.

 

The condition I am using doesn't seem to work

@equals(items('Apply_to_each')?['Date Checked'], null)

 

Can someone please help?

 

This is my  current flow - 

Screenshot 2019-01-10 at 5.17.15 PM.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @mowgli512,

 

Do you want to check if a field in Excel is empty or not?

Please consider using the function empty:

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

I have made the following flow for your reference.

After the action List rows present in a table, add a condition with the following code in Advanced mode:

@equals(empty(items('Apply_to_each')?['Date']), bool('True'))

 

Under if yes branch, send a push notification.

A screenshot for your reference.

1.PNG2.PNG

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Hi @mowgli512,

 

Do you want to check if a field in Excel is empty or not?

Please consider using the function empty:

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

I have made the following flow for your reference.

After the action List rows present in a table, add a condition with the following code in Advanced mode:

@equals(empty(items('Apply_to_each')?['Date']), bool('True'))

 

Under if yes branch, send a push notification.

A screenshot for your reference.

1.PNG2.PNG

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

This is a great solution. Now that advanced mode for conditions is not longer available, could you explain how this would translate in basic mode? 

Thanks in advance!

Highlighted

To the left cell put function

empty(items('Apply_to_each')?['Date'])
then to middle 'is equal to' 
to last cell in the right put 'true'
emptyempty

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (7,930)