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?
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.
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!
Flow Community Manager
I get the same thing in my flow and this is how mine looks
@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!
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!