Passing date into Flow as parameter throwing error for SharePoint date column.

(0) Share

Report

Posted on by Ananda

147

Passing date into Flow as parameter throwing error for SharePoint date column.
PowerApp Code -

Text(DataCardValue13.SelectedDate,"[$-en-US]mm/dd/yyyy","en-US")

Error - string 'mm/dd/yyyy/' does not validate against format date,

In flow I've also used formatdatetime.

Code - formatdatetime(triggerBody()['Updatefileproperties_EndDate'],'mm/dd/yyyy')

But same result.

Any thoughts on this..?

Appreciate your reply on this.

Thank you.

ananda

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

haroldk Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

SharePoint Dates are usually formatted yyyy-MM-dd

Need to use uppper case M for month since lower case m is minutes

Was this reply helpful? Yes No
Ananda 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Tried
Text(DataCardValue13.SelectedDate,"[$-en-US]MM/DD/YYYY","en-US"),
Same error.
Thanks

Was this reply helpful? Yes No
haroldk Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

try this

Text(DataCardValue13.SelectedDate,"[$-en-US]yyyy-MM-dd","en-US"),

Using all caps is not right and it should be year month day for SharePoint dates

Was this reply helpful? Yes No
Verified answer

Ananda 147 on at

Like
a
(8)

Report
Copy link

Link copied!

I've tried below code and it worked. It's not the Upper Case vs Lower Case.

Text(DataCardValue13.SelectedDate, "[$-en-US]yyyy-mm-dd").
It's quite strange.
Thank you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yo tengo el mismpo problema y con la solucion que comentas no se ha solucionado

Les comaprto el error que me aparece

Was this reply helpful? Yes No
nathanjfield 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked for me, and note that my SharePoint time format is UK (dd/mm/yyyy), but once passed from PowerApps > Power Automate > SharePoint List the date was automatically converted from UK to US.

Was this reply helpful? Yes No
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

I've tried everything here and I still get the error?

I am not using a date picker, but simply text. When I try something like Text(ThisItem.To,"yyyy/mm/dd") I still get the STRING issue?

ThisItem is the SP List and To is a date text column?

Was this reply helpful? Yes No
Johnolnes 234 on at

Like
a
(0)

Report
Copy link

Link copied!
This worked for me.
I removed the regional formatting before the "yyyy-mm-dd", and simply had the flow ask in PA for the date.
Text(DataCardValue4.SelectedDate,"yyyy-mm-dd")

Was this reply helpful? Yes No