cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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

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

Highlighted
Administrator
Administrator

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

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
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!
Highlighted
Frequent Visitor

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

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
Highlighted
Dual Super User III
Dual Super User III

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

@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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,399)