News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Text based date arrivi...

Power Automate - Using Flows

Unanswered

Text based date arriving in 2 formats is breaking a flow... (2022/01/13 & 13-01-2022)

(0) Share

Report

Report

Posted on by The_blue

116

Hi, i've inherited a flow that's suddenly started to fail. Some other system is adding text dates to a SP list

Currently there's a set variable:

split(items('Problem_Date')?['Effective_x0020_Start_x0020_Date'], '-')

Followed by a compose:

formatDateTime(concat(variables('DS')[0], '-', variables('DS')[1], '-', variables('DS')[2]), 'yyyy-MM-dd')

This is failing out on the dates with slashes.

How can i get the output of the compose to be correct for both variants?

All responses Img

All responses (1)

Answers Img

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Re: Text based date arriving in 2 formats is breaking a flow... (2022/01/13 & 13-01-2022)

Hi @The_blue ,

1\ Is the first date April 9th or September 4th?

2\ Do you have dates in other formats?

Best Regards,

Wearsky

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,651 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans