I would like to convert the date value into long date format and i am not sure how to get it done.
Current date value - 2022-10-21,2022-10-24,2022-10-25
Expected date value -
Friday, October 21,2022
Monday, October 24, 2022
Tuesday, October 25, 2022
Flow Output details -
ParseJSON & Select action output -
[
{
"Value": "2022-10-21"
},
{
"Value": "2022-10-24"
},
{
"Value": "2022-10-25"
}
]
When i join them using the JOIN expression -
{"Value":"2022-10-21"},{"Value":"2022-10-24"},{"Value":"2022-10-25"}
When i am using the replace expression - my output is
2022-10-21,2022-10-24,2022-10-25
Is it possible to get the long date format Expected value -
Friday, October 21,2022
Monday, October 24, 2022
Tuesday, October 25, 2022
And also another issue is when the users select just one day the ParseJSON output ends up like this
[
{
"Value": "2022-10-24T06:00:00.000Z"
}
Replace action - output
2022-10-24T06:00:00.000Z
]
Need some suggestions on how to get the multi dates and single date to show up in this format
Friday, October 21,2022
Solved! Go to Solution.
Add these actions after your Compose-Replace
use formatDateTime(variable('Date 1'),'ddd, dd MMM yyyy')
@SudeepGhatakNZ - Thank you for taking the time to help me out
but this does not work for my scenario
My flow output details -
ParseJSON & Select action output -
[
{
"Value": "2022-10-21"
},
{
"Value": "2022-10-24"
},
{
"Value": "2022-10-25"
}
]
When i join them using the JOIN expression - my output is
{"Value":"2022-10-21"},{"Value":"2022-10-24"},{"Value":"2022-10-25"}
When i am using the replace expression - my output is
2022-10-21,2022-10-24,2022-10-25
Now i am trying to convert my replace output to
Friday, October 21,2022
Monday, October 24, 2022
Tuesday, October 25, 2022
Not sure if i am doing it right but i am stuck with this.
Add these actions after your Compose-Replace
User | Count |
---|---|
89 | |
41 | |
22 | |
20 | |
16 |
User | Count |
---|---|
138 | |
56 | |
47 | |
36 | |
26 |