Survey123 Report - the CreationTime field incorrectly adjusts the time in a Report.

DarrenLloyd__DOIT

I am working on a Survey123 custom report that uses the default {CreationDate} field. When the CreationDate field is used in the report it automatically adjusts the time. For example, In Survey123 the submitted time is 13:09 but when the {CreationDate} field is used in a report, the time is adjusted to 5:09 PM. Basically it changes it to a 12-hour format and adds 4 hours. Do I need to adjust the time in Survey123 Connect prior to the report? or can I use an expression in the report? 

DarrenLloyd__DOIT

I don't want to take credit for this solution so here is the link to the original solution.

https://community.esri.com/t5/arcgis-survey123-videos/survey123-create-report-action-in-microsoft-power/td-p/1253057/page/2

Here is my solution based on the US Eastern time zone.

1) In Survey123 Connect XLS add a text utcOffset field. Then insert the following into calculation field ---> if(pulldata("@property", 'utcOffset')='-4','-04',if(pulldata("@property", 'utcOffset')='-5','-05',pulldata("@property", 'utcOffset'))). Use "hidden" In the Appearance column.
2) In MS Power Automate under the Create Report step, place the newly created utcOffset feature attribute in the UTC offset field.