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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 248 Super User 2026 Season 1
David_MA 207 Super User 2026 Season 1
Power Platform 1919 101 Super User 2026 Season 1