Convert dataverse date format in Flow - VERY URGENT

(0) Share

Report

Posted on by ArisTale

Hi there,

I have a Dataverse table where a date is populated in US format, so (mm/DD/yyyy).

I know how to convert in to European format to dd/MM/yyyy, but it shows numbers...

I want to convert this to dd/Month/yyyy (date and year as number and month as a word or its abbreviation.), using a Compose operation in Automate to then use in the body of a Send an email action.

The column name for the date value in Power Automate is ['body/hra_raestleave'].

Please can someone help?

Many thanks,

Alexandra

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Heya,

Did you mean to post this in the Power Automate forums instead of the Power Apps forums?

if you use something like formatDateTime() and then for your formatting use "dd/MMMM/yyyy" that will show then name rather than the number for the month

Cheers,

Was this reply helpful? Yes No
ArisTale 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Hei,
Yes, you are right about forums.

May I ask you to elaborate on formatDateTime() ? In what action and how can I use (find) formatting like "dd/MMMM/yyyy"?

I am very new to Automate flow(((

Thank you in advance!
Alexandra

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

When you type in the compose, the expression editor (where you pick the items to display) is available in the second tab, so you will need to use the formatDateTime function in there, pick the item you want to apply the formatting to, then define how you want it formatted

Click inside the brackets as that is where we want to insert the dynamic content, then click on the dynamic content tab

clicking the item we want to format, which then inserts it inside the brackets we clicked:

Then we add a comma to the end and define the format we want it in, press Enter when done and then click update:

Running the flow we can see it has modified the date:

Was this reply helpful? Yes No
ArisTale 72 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for such a detailed answer!

Last question: does it work for "Date Time" only or for "Date only" date fields as well?

Regards,
Alexandra

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

A 'date only' field is actually a datetime field technically, it just has a time of 00:00 😉 so yes it will!

Was this reply helpful? Yes No
boom_powerapps 101 on at

Like
a
(0)

Report
Copy link

Link copied!

@iAm_ManCat Hello, do you have an example where this works for a dataverse table field? I see this example shows the process for a SharePoint List.

Was this reply helpful? Yes No