cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Date and Create

Hi Guys, 

 

Wondering if you can help as this is driving me insane!

 

So from the app it passes 2 Dates 1. Order Date and 2. Required by Date

 

Varibles.PNG

 

Ok then i want to create an item in sharepoint so i use a compose function FormatDatetime with a dd/MM/yyyy at the end 

 

Compose.PNG

 

And i get the error 

 

Error.PNG

 

But if i use FormatDateTime with MM/dd/yyyy i get no errors, it creates the item in sharepoint with a date of dd/MM/yyyy

 

but then the date in a send email function shows as MM/dd/yyyy, 

 

i guessed at regional setting in sharepoint which are set as UK and thats admin settings for the whole site. 

 

Any ideas?

 

3 REPLIES 3
Highlighted
Super User III
Super User III

Hi @newitguy ,

 

Use this formula as part of your compose: 

formatDateTime(requireddatevar,'MM/DD/yyyy')

 Let me know if you need I can help you further.

 

Also, see if this thread helps you to solve your issue:
https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-change-Flow-date-from-YYYY-DD-MM-t...

 

Note: if this helps mark it as the solution

 

Regards,

Krishna


I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Proud to be a Super User!

Regards,
KrishnaV
Business Applications MVP
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
Highlighted
Super User
Super User

You will get better help on the PowerAutomate forum BUT...

 

Any time I am adding a to a SharePoint list or comparing to a SharePoint list date column I need to have it in the 

 

formatDateTime(DateField, 'yyyy-MM-dd')

 

format. I am in the US so it could be different for different regions.

 

The way you can easily figure out how it has to be is to add a item on your SharePoint list that includes the date (from the sharepoint list). Then create a temp flow that is just a button and does the 'Get item' or 'Get items' and put a compose below it that you just select the date field from the dynamic content. Run the flow and then see how the date in that compose section is formatted. That will show you how it is formatted coming out, which is how it will need to be formatted going back in.

Frequent Visitor

Hi, 

 

Sorry just noticed that i posted this on powerapps community

 

Unfortunately thats the formula that im using in my compose, MM/dd/yyyy works but dd/MM/yyyy gives me the error. 

 

ill re post in the power automate community 

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,295)