cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmangiante
Helper V
Helper V

String was not recognized as a valid DateTime with SharePoint list date field

Hello,

 

I have a list in SharePoint and have a date field; my regional setting are for Italy, so I see in the list a date in format "dd-MM-yyyy"; I created a flow that after various operations must insert the date in the "Update file properties" action; as said, I insert (and see) the day in the "italian" format, but when the trigger start "When a new item is created" I see the date in the format "MM-dd-yyyy".

 

I tried to format the date with the funcion formatDateTime inside a Compose action, but when the flow fill the file property related to date I obtain the error:

 

String was not recognized as a valid DateTime. clientRequestId: eed3d460-eb9e-4b38-92c9-940110c2e2a9 serviceRequestId: e111719e-101a-5000-d3c1-a8963c9b2c47

I suppose that I have this error because the field in the file is declared as Date,but I suppose that what I have in the Compose output is a string.

 

Any help? Is it possible to trasform the string in a date after the compose?

 

Marco

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

Hi @mmangiante,

 

Could you please share a screenshot of the configuration of your flow?

Could you please share more details about your sharepoint list?

Could you please share more details about your reqyuirement?

 

How does you format the date with the funcion formatDateTime inside a Compose action?

 

Please share more details so we would try to provide a proper workaround for you.

 

 

Best regards,

Alice

Hey, @mmangiante!

 

It appears as though @v-yuazh-msft would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

 

Thank you for being an active member of the Flow Community!

 

-Gabriel

Flow Community Manager

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Linuxcable23
Frequent Visitor

I get the same thing in my flow  and this is how mine looks 

 

 

Expression

convertTimeZone (utcnow(),'UTC','Central America Standard Time',' HH:mm')
 
screenshot of flow step its self 
 
OOO Date Time Convert .jpg

@Linuxcable23 , can you post the screenshot of the error that you are getting. 

 

Note: the time conversion that you are making is to (HH:mm) and is that the datatype at source? If not, you can use the "Convert Time Zone" action for better understanding. 

 

Hope this helps!

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (916)