Notifications
Announcements
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 -
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#empty
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.
Best regards,
Mabel
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!
To the left cell put function
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 519 Super User 2025 Season 2
Tomac 296 Moderator
abm abm 232 Most Valuable Professional
