topic Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow in ArcGIS Connectors for Power Automate Questions

Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

LeviCecil — Mon, 20 May 2024 17:52:19 GMT

I'm trying to convert the creation date field from an AGOL hosted feature service from UTC to a date string in an email alert flow in Power Automate. I've only been able to find examples for converting dates from Survey 123 or Excel, and haven't found anything that works. Any help would be appreciated.

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

DominicRobergeIADOT — Mon, 20 May 2024 18:00:00 GMT

@LeviCecil

try this (it's a expression):

convertTimeZone(addSeconds('1970-1-1', Div(YOURFIELD NAME,1000),'MM/dd/yyyy hh:mm:ss tt'),'UTC','Central Standard Time','MM/dd/yyyy hh:mm:ss tt')

Hope this can help you

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

NataliyaLys — Mon, 20 May 2024 18:18:57 GMT

This is an expression that I have, and it works as expected:

convertTimeZone(addSeconds('1970-1-1', Div(items('Apply_to_each_3')?['Attributes/CreationDate'],1000),'MM/dd/yyyy hh:mm:ss tt'),'UTC','Central Standard Time','MM/dd/yyyy hh:mm:ss tt')

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

Sean_Works — Mon, 20 May 2024 19:10:11 GMT

You may also want to explore a regular expression solution similar to the two examples below that extract date or time from a combined datetime field:

Text.ParseText.RegexParse Text: CSVDateRange TextToFind: $'''([0-9]+(/[0-9]+)+)''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> Position Matches=> DateMatch

Text.ParseText.RegexParse Text: CSVDateRange TextToFind: $'''(0?[0-9]|1[0-9]|2[0-3]):00\\s[A-Za-z]+''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> Position Matches=> TimeMatch

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

LeviCecil — Mon, 20 May 2024 20:56:33 GMT

Thanks for this. Would you do this inside a compose trigger and use the output in the email body?

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

NataliyaLys — Mon, 20 May 2024 21:15:44 GMT

Add it into your email body and an expression/function

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

LeviCecil — Tue, 21 May 2024 20:44:51 GMT

I'm trying this in the email body after fetch updates and keep getting the error "Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The template action 'Send_email_(V2)' at line '1' and column '1842' is not valid: "The template function 'items' is not expected at this location.".'.'."

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

RobertAnderson3 — Thu, 23 May 2024 16:31:14 GMT

The items('Apply_to_each') implies it's being done in a loop for multiple values. How is your current flow set up? It's just taking the time from one row right? For survey mine looks like @addSeconds('1970-1-1', Div(triggerOutputs()?['body/feature/attributes/startdatetime'], 1000))

Can you share your flow and show where you're bringing the time in and converting it and placing it in the email?

There are also "Add time" and "Convert time" actions that I use in some flows that can read it properly.

Re: Convert AGOL Hosted Feature Service Creation Date in Power Automate Flow

LeviCecil — Tue, 28 May 2024 21:03:42 GMT

Ah, thanks! I tried it again and it worked!