Hi,
I have a form with a date only field that for some reason shows the date incorrectly when I use it in Power Automate.
For example, I select 03/05/2023 (UK time) and save the record. The front end shows it as 03/05/2023 but when I go to access the date in Power Automate it shows 02/05/2023.
So I added another field that was set to DateAndTime, selected the same date and this shows the date correctly as 03/05/2023.
This is the trigger output:
Date Only: "new_customerfacetofacemeeting": "2023-05-02"
Date and Time: "new_customerfacetofacemeetingdatetime": "2023-05-03T07:00:00Z"
Both fields are set to user locale and both the user who enters data and the owner of the flow have their time zone set to UK time.
Any idea what's going on?