cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmangiante
Level 8

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
Community Support Team
Community Support Team

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

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!
Linuxcable23
Level: Powered On

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

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 198 members 6,592 guests
Recent signins:
Please welcome our newest community members: