So I was having trouble with the submission time of my form showing the wrong time (4 hours off). I added the addHours function to my flow and it's showing the correct time now but the format is completely off.
Solved! Go to Solution.
Hi @Vincebk
Thank you for posting.
According to your description you selected cell's format as Custom to show m/d/yyy h:mm but it shows wrong DateTime Format. If any misunderstanding, please kindly let me know.
I tried to reproduce your scenario but it works fine for me.
This is my flow:
Expression:addHours(outputs('Compose'),-4,'yyyy-MM-dd HH:mm')
Then save Flow and can test it.
When a new response is submitted as below
A new row will be created as below:
The submit time format is Custom m/d/yyy h:mm
Hope the content above may help you.
Best Regards
Lily
Hi @Vincebk
Thank you for posting.
According to your description you selected cell's format as Custom to show m/d/yyy h:mm but it shows wrong DateTime Format. If any misunderstanding, please kindly let me know.
I tried to reproduce your scenario but it works fine for me.
This is my flow:
Expression:addHours(outputs('Compose'),-4,'yyyy-MM-dd HH:mm')
Then save Flow and can test it.
When a new response is submitted as below
A new row will be created as below:
The submit time format is Custom m/d/yyy h:mm
Hope the content above may help you.
Best Regards
Lily
Wow, you are the best! Thank you for that. Could I bother you with another problem if you don't mind?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
64 | |
55 | |
29 | |
27 | |
25 |