Date Time Fields (Date Only and User Local – Behaviour) in Power Automate (Dataverse)
The article discusses the behavior of date and time fields in Power Automate (Dataverse) when the format is set to date only and the time zone adjustment is set to user local. The article explains how the convertTimeZone function can be used to convert the UTC date to the user's time zone. However, when the format is set to date only, the function does not work as the date is not in UTC format. The article suggests changing the time zone adjustment to date only or time zone independent for the field to fix the issue.
Article 20m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time