Missing date field from a list when sending a v3 email

[Firemaster4076]

Good morning/afternoon/evening

I have a list which is populated from a form. List is filling in nicely with the dates as shown below

Date from 01/08/2021

Date to 07/08/2021

Off the back of this an approval is sent out. within the approval text of

@{outputs('Add_from_the_form_details_to_the_list')?['body/Title']} has requested annual leave

From - @{outputs('Add_from_the_form_details_to_the_list')?['body/Datefrom']} to @{outputs('Add_from_the_form_details_to_the_list')?['body/Dateto']}
Consisting of @{outputs('Add_from_the_form_details_to_the_list')?['body/HolidayRequesteddaystotal']} days
This leaves @{outputs('Add_from_the_form_details_to_the_list')?['body/DaysRemaining']} remaining

the date from and the date to come out 2021-08-01 instead of the other way around 01-08-2021

And then when it is approved an email is then to be sent using the send email notification (V3)

But when you search for the to and from field in the share point list to add to the email message they are no where to be seen all the other fields are present.

[ekarim2020]

For dates you can use the formatDateTime function to get the format you need:

formatDateTime(outputs('Get_Form_response_details')?['body/submitDate'], 'dd-MM-yyyy h:mm tt')
formatDateTime(outputs('Add_from_the_form_details_to_the_list')?['body/Datefrom'], 'dd-MM-yyyy')

 

When you say you searched for the To and From dynamic content, did you enter the the names of the field in the Dynamic content search box:

Ellis

[Firemaster4076]

---

@ekarim2020 wrote:

For dates you can use the formatDateTime function to get the format you need:

formatDateTime(outputs('Get_Form_response_details')?['body/submitDate'], 'dd-MM-yyyy h:mm tt')
formatDateTime(outputs('Add_from_the_form_details_to_the_list')?['body/Datefrom'], 'dd-MM-yyyy')

---

Sorry not sure how I use the Format date (The above) with the date from and date to fields, could you help a complete newbie with this

Cant believe it just physically searching for the fields shows them geez how easy was that.

On a side note why did it not just list them?

[ekarim2020 · Accepted solution]

To get to real power of Power Automate you will need to learn how to use expressions. Most things you may want to do are just not possible without expressions. See Introduction to expressions in Power Automate for some weekend reading!

However, you could try to copy and paste the following code:

From - @{formatDateTime(outputs('Add_from_the_form_details_to_the_list')?['body/Datefrom'], 'dd-MM-yyyy')} to  @{formatDateTime(outputs('Add_from_the_form_details_to_the_list')?['body/Dateto'], 'dd-MM-yyyy')}

into the Start and Wait for approval action (clear out what is already there, and place the cursor at the start of a new line):

This should give you the following:

This should work - assuming I have got your data properties for the from and to field correct.

>>>On a side note why did it not just list them?

Power Automate is trying to be clever and tried to anticipate what it thinks you need. It doesn't always get it right. If you don't see the dynamic content you are looking for always try a search!

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[Firemaster4076]

brilliant ekarim, i will take that as my homework and then pick the expression apart so i can see the workings. it is now getting the right date format cheers