Unanswered

Json array DateTime format to mm/dd/yyyy

(0) Share

Report

Posted on by cha143

31m ago

please help me to format json datetime (2023-07-03T09:03:10) to mm/dd/yyyy format and how to get each day first time in and last time out from json file

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

SamLed 2,338 Moderator on at

Like (0)

Report

Hi,

Sorry, I'm not sure to have correctly understood the "first time in and last time out" expression. Does it mean "Unique" or "Lowest and greatest for each date" ?

If that means "Unique" you could do that this way, assuming you have a date string array:

Results in:

______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
If that means "lowest and greatest", then it's a bit more complex:

Assuming we have this input array :

We want this output array:

Now here's the flow:
Start by initializing 3 variables, I use a compose to create my input datetime array, replace it by your input array:

Add a Select action to fetch date without time from array, add a compose to get unique dates and an Apply to each giving it the compose outputs:

Inside apply to each, add a filter array to fetch only datetimes matching current date, set both MinDate and MaxDate variables with first date from resulting array and add a new apply to each giving it the filter array outputs:

In this loop, we're checking if current date is lower than MinDate or Greater than MaxDate and store it in respective variable if true:

Now, inside first loop, just after second one, let's append MinDate and MaxDate formated to desired format to output array , I check if MinDate is not equal to MaxDate to avoid having twice time the same date if it was alone in input array:

Finally, below first loop, let's display resulting output array:
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report

An optimized version of previous proposal:

Where Append Min expression is :
replace(replace(replace(replace(replace(replace('yyyy-MM-ddTHH:mm:ss', 'yyyy', substring(outputs('Compose_-_Min_datetime'),0,4)), 'MM', substring(outputs('Compose_-_Min_datetime'),4,2)), 'dd', substring(outputs('Compose_-_Min_datetime'),6,2)), 'HH', substring(outputs('Compose_-_Min_datetime'),8,2)), 'mm', substring(outputs('Compose_-_Min_datetime'),10,2)), 'ss', substring(outputs('Compose_-_Min_datetime'),12,2))

Append Max expression is:
replace(replace(replace(replace(replace(replace('yyyy-MM-ddTHH:mm:ss', 'yyyy', substring(outputs('Compose_-_Max_datetime'),0,4)), 'MM', substring(outputs('Compose_-_Max_datetime'),4,2)), 'dd', substring(outputs('Compose_-_Max_datetime'),6,2)), 'HH', substring(outputs('Compose_-_Max_datetime'),8,2)), 'mm', substring(outputs('Compose_-_Max_datetime'),10,2)), 'ss', substring(outputs('Compose_-_Max_datetime'),12,2))

______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
cha143 55 on at

Like (0)

Report

hi thank you for answering here is the sample of dates that i converted in excel manually

i need to capture the time in and time out of each date see the image for sample. please help me to create it in the powerautomate

Was this reply helpful? Yes No