Inconsistent Date format in Forms and List

Question

I noticed that there is an inconsistency in date format. I am having trouble with merging these two application as forms date entry is M/D/Y while List is D/M/Y.

What are my options in merging these two to be consistent ? I prefer D/M/Y and I use power automate to populate the List.

Answer 1

Dear @DarrenLee JingHern

Thank you so much for contacting Microsoft Q&A Forum. 

Based on your descriptions, I can see that date format inconsistencies between Microsoft Forms (which uses M/D/Y) and SharePoint Lists (which you're using in D/M/Y) can cause confusion, incorrect data entries, or even automation failures in Power Automate. Since you're using Power Automate to populate the List, I have an idea that you can check if it can help your preferred D/M/Y format: 

Format the date in Power Automate before writing to the List: you can use the formatDateTime() function in Power Automate to convert the date from Forms into your preferred format. Example expression: 

formatDateTime(triggerOutputs()?['body/DateField'], 'dd/MM/yyyy') 

This ensures that the date is stored in the List in D/M/Y format regardless of how it was entered in Forms. 

References:  

• Customize or format date and time values in a flow - Power Automate | Microsoft Learn 
• Use format data by examples to change the format of data with Power Automate - Power Automate | Microsoft Learn 

Besides that, I found this case that may have additional information if you're getting errors like "provided text can't be converted into a valid datetime", you can consult for more information: How to fix Date Conversion Power Automate Flow - Microsoft Q&A 

Also, as a forum moderator, I have limitations in my testing environments and cannot access the internal databases to help you with this Power Automate feature. Therefore, I highly recommend you to reach out Find Answers | Microsoft Power Platform Community for getting more professional help, there will be very professional people to tell you about the steps on how to realize this function.   

I hope this information can help you and please kindly correct me if I misunderstand your concern. 

Wish you a pleasant day! 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

Hi,

I'm Sumit, here to help with your query on the Microsoft Q&A forums.

Apologies for any inconvenience you are experiencing. I am happy to help you today.

Microsoft Forms date entries typically follow the M/D/Y format based on browser or regional settings. You cannot set the date format directly within Forms, but you can change the browser language/region to English (United Kingdom) to get D/M/Y. Also, Microsoft Lists shows dates in the format according to its regional or site settings. You can set the List’s regional settings (usually via OneDrive or SharePoint site regional settings) to ensure D/M/Y format display in Lists.

For PowerAutomate, I recommend reaching out to Power Platform Community to get a better answer:

https://community.powerplatform.com/?redirectedFrom=https://community.powerplatform.com/t5/Power-Apps-Community/ct-p/PowerApps1

I hope you find this information useful. If you have any more questions, don't hesitate to reach out. Otherwise, please take a moment to rate the thread. Wishing you good luck!