Hello -
I have built a flow that carries out the following steps:
1. Trigger - MS Forms response
2. Populates an MS Word Template with forms responses
3. Updates File Properties in Sharepoint
The flow is running, but it is populating the date incorrectly in the MS Word Template. I want the date to populate in the MS Word Template as MM-dd-yyyy, but it is populating like this example:
2024-03-02T08:00:00+00:00 (with the time added in an the month, date, and year out of order). This is confusing to me because it appears to be formatted correctly in the flow outputs:
...and in Sharepoint:
It's the Word template that is not updating correctly:
Here is a screenshot of that part of my flow...
Get Converted Time Zone Exp:
formatdatetime(variables('PostDeadline'),'MM-dd-yyyy')
...where the posting deadline is the output of the Get Converted Time Zone action.
Any ideas on how I can get the date to populate correctly (without the time) in the Word template?
Thank you!
