Announcements
I need to convert the cr416_datepicker value format to just "yyyy-MM-dd" without this time and full fill the condition, any idea ?
Hi @milan6412 ,
Please change is equals to contains.
Best Regards,
Sunshine Gu
I tried but it gives me this error message
since the other records doesnt have the datefield , it's returning empty. so I can't have contains
Please try this expression:
if(empty(items('For_each')?['cr416_datepicker']),null,items('For_each')?['cr416_datepicker'])
Use coalesce() to check if the value is null and, if so, provide an alternative value (here an empty string)
Replace
items('For_each')?['cr416_datepicker']
with
coalesce(items('For_each')?['cr416_datepicker'], '')
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
Haque 227
Expiscornovus 225 Most Valuable Professional
