Power Platform Community Forum Thread Details

Hi everyone,

I am reading a dataverse table, when a new record is created, run this flow.

Based on the column "DatesRequested", I create an array with these string values:

Then, I need to get each value of this array, convert to Date format and use the result to "Add a new row" in other table.

The array is:

array(triggerOutputs()?['body/cr815_datesrequested'])

How can I get each value and convert to date?

In a Compose I have:

formatDateTime(convertFromUtc(item()?['cr815_datesrequested'], 'yyyy-MM-ddTHH:mm:ssZ'), 'MM-dd-YYYY')
 
But it is not working.
 
I get this error:
 
Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'formatDateTime(convertFromUtc(item()?['cr815_datesrequested'], 'yyyy-MM-ddTHH:mm:ssZ'), 'MM-dd-YYYY')' cannot be evaluated because property 'cr815_datesrequested' cannot be selected. Property selection is not supported on values of type 'String'.