Answered

Date Formatting from Form to Sharepoint List

(0) Share

Report

Posted on by Niven

Hi,

I have built the below flow to take answers from a form and then populate a sharepoint list, fairly simple but the dates (there are multiple different dates in the form) from the answers in the form wont format the way I want them too (DD-MM-YYYy). I have checked the local settings in SP and they are all correct but it keeps giving me YYYY-MM-DD. Where am i going wrong ?.

Any help would be great.

Screenshot 2024-06-04 102805.png

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Niven ,

Because the format of the return value of the date of the SharePoint connector is always yyyy-MM-dd, which does not change.

The default display format of dates in SharePoint lists is MM/dd/yyyy.

If you want the date format to be displayed in dd-MM-yyyy in the email body, please try formatDateTime in send an email.

Like this:

formatDateTime(outputs('Create_item')?['body/Date'],'dd-MM-yyyy')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Niven 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft

Thanks for the response, I don't need any formatting in the email that is just to notify staff that the form has been completed and then they go to the SharePoint list.

You say "Because the format of the return value of the date of the SharePoint connector is always yyyy-MM-dd, which does not change." But I created a separate SP list on another site and changing the reginal settings changed the formatting of the dates. I also mirrored the form and flow and it worked ?

Are you saying there is no way to change the formatting of dates in SP ? I currently get YYYY-MM-DD.

Can I also add that my data types in the SP list are single lines of text and not dates as the flow wont work if they are set to dates, I don't know if this could be affecting it.

Thanks

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Niven ,

It looks like your expression is written incorrectly, please see this test:
My MS Form:

My Flow:

formatDateTime(,'dd-MM-yyyy')

My SharePoint List:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Niven 22 on at

Like (0)

Report
Copy link

Link copied!

HI @v-yetonggu-msft

When entering your expression i get an error, Please see below. Thank you.

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Niven ,

Please add your date dynamic content to the expression, I'm just an example.

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

First Click the Dynamic Content.

Then add the Dynamic Content to formatDateTime(,'dd-MM-yyyy') expression.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Niven 22 on at

Like (0)

Report
Copy link

Link copied!

Apologies, Thank you for clarifying, I inputted The expressions and added my data. Testing the flow I get the following error. Thank you for your help.

Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Niven ,

This means that you did not enter any date, so try this expression:

if(empty(DateDynamicContent),null,formatDateTime(DateDynamicContent,'dd-MM-yyyy'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Niven 22 on at

Like (0)

Report
Copy link

Link copied!

Perfect That worked, Thank you for your help.

Was this reply helpful? Yes No