Unanswered

Change date format received from MS Forms in MS Flow for use in email

(1) Share

Report

Posted on by PeggyLang

381

I have an approval 'Leave Request' flow. It is triggered when a response has been received from an MS Form.
It runs successfully and produces the desired outcomes, however . . .
the email sent out via MS Flow upon approval contains the following;
'leave requested for yyyy-mm-dd to yyyy-mm-dd has been approved.'
I would prefer my email to read;
'leave requested for MMM dd yyyy to MMM dd yyyy has been approved.' i.e., Nov 12 2020 instead of 2020-11-12
I'm guessing I need to initialize variable to accomplish this, however, I'm not sure where in the steps of the flow to add this, nor the syntax for it.

Any help GREATLY appreciated.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

Paulie78 8,422 Moderator on at

Like (1)

Report
You've sort of answered it yourself really 😄. An expression like this will do what you want:
formatDateTime(outputs('Date'), 'MMM dd yyyy')
Just replace outputs('Date') with whatever your date value is.

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

@Paulie78 where in my flow do I insert that experssion. I've 'tinkered' with it, but have not yet been successful.

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report

Whereever it is you are applying the date field. So in your case, in your "send an email" action. I guess in the body of your email you are inserting dynamic content. You simply delete that dynamic content and put in the expression instead.

Within the expression delete the bit I put outputs('Date'), leave your cursor placed in the expression and go back to your dynamic content and select the date field you want to reformat and it will go into your expression.

No need to add another variable etc, because it is only being used once. If it does not make sense, I will try to explain it another way.

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

@Paulie78 , so clearly I need my hand to be held . . . 😣
I didn't remove the field that were working just yet, I just added what I interpretted the replacement to be;

Here is the error message that was returned;

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

It's because you have picked all of the response details from the form (which is an object of values) instead of just the date return from the form response. So you almost have it correct, you just picked the incorrect dynamic data.

Was this reply helpful? Yes No
PeggyLang 381 on at

Like (0)

Report

FIGURED IT OUT !!!!

🎉💃👏

THANKS SO MUCH !!!!

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

Well done, better click that accept solution button then! 😉

If I answered your question Accept it as a solution ✔️
If I helped you out, please give me some Kudos 👍
Thanks 😙

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi - I think I have got this wrong somehow; the dynamic field I am trying to convert date on is 'Firstdateofleave'??

formatDateTimetrigger((['Firstdateofleave']), 'dd MMM yyyy')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi - I think I have got this wrong somehow; the dynamic field I am trying to convert date on is 'Firstdateofleave'??

formatDateTimetrigger((['Firstdateofleave']), 'dd MMM yyyy')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

sorted....
formatDateTime(triggerBody()?['Firstdateofleave'],'dd MM yyyy')

Was this reply helpful? Yes No