I have a flow set up to use the ArcGIS "When a record is updated in a feature layer" trigger, and send an email with information about the feature layer. The feature layer was created with Survey123 Connect. I have a date field (WODate) in the form that I'd like to pass through on the email. However, Survey123 likes to use Unix instead of an easily readable format, so I get emails saying "Work Order Submitted on 1670432400000". I've gone through a couple different calculations that I've found here on Geonet and on other non-Esri forums, but none of them seem to be working. Any suggestions for how I can get "1670432400000" to read as "12/7/22" or "12/7/22 12:00 pm"?
These are the options I've tried so far:
formatDateTime(addSeconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/WODate'],1000)), 'M/d/yy h:mm tt')
addseconds('1/1/1970', Div(WODate,1000) , 'MM/dd/yy')