web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate cut one line two multi...

Power Automate

Unanswered

cut one line two multiple lines (separator is comma)

(0) Share

Report

Report

Posted on by Sifu

834

hi,

i have a string like: 20201103,20201106,20201120

I need to get it something close to a date format and display below each other, for example:

2020-11-03

2020-11-06

2020-11-20

i tried with split function or some other tricks but wont work... any suggestions?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

crowdjs 133 on at

Like (0)

Report
Use Split to separate the dates stored as strings.
then use substrings to get the year-month-date.
Then end by using concat.
split(variables('text'),',') substring(outputs('Compose_3'),0,4) substring(outputs('Compose_3'), 4, 2) substring(outputs('Compose_3'), 6, 2) concat(outputs('Substring_to_find_year'),'-',outputs('Substring_to_find_month'),'-',outputs('substring_to_find_day'))

Was this reply helpful? Yes No

Join the conversation