Reply
Highlighted
Level: Power Up
Posts: 2
Registered: ‎10-06-2017
Accepted Solution

how to embed a response body/link into approval email

Hi,

I am trying to build a flow where a trigger is: Submitting a form Follow by action: sending approval email. Ideally I would like to have the body of the response embedded into approval email, however the only option I Have is to embed a response id which makes no sense.

Can you please help?

br, Kamil


Accepted Solutions
Community Support Team
Posts: 4,226
Registered: ‎09-20-2016

Re: how to embed a response body/link into approval email

Hi @kazmierczakkami,

If here you mean the Microsoft Forms trigger, then please follow the steps below:

1. Add the form response trigger,

2. Add aother Microsoft Forms action->Get response details,

3. Select the corresponding From ID, then sepcify the response ID with the following expression:

first(triggerBody()?['value'])?['resourceData']?['responseId']

4. Add the Send Approval Email action, under the body, format the result as you wish

See screenshots:

4.PNG

 

Regards,

Michael

 

View solution in original post


All Replies
Community Support Team
Posts: 4,226
Registered: ‎09-20-2016

Re: how to embed a response body/link into approval email

Hi @kazmierczakkami,

If here you mean the Microsoft Forms trigger, then please follow the steps below:

1. Add the form response trigger,

2. Add aother Microsoft Forms action->Get response details,

3. Select the corresponding From ID, then sepcify the response ID with the following expression:

first(triggerBody()?['value'])?['resourceData']?['responseId']

4. Add the Send Approval Email action, under the body, format the result as you wish

See screenshots:

4.PNG

 

Regards,

Michael

 

Level: Power Up
Posts: 2
Registered: ‎10-06-2017

Re: how to embed a response body/link into approval email

Hi

I managed the first 3 steps thanks.

No as it goes to the email how do I embed specific answers from the form to the body.

At this stage I can only add Response ID

TIA,

K

Level: Power Up
Posts: 1
Registered: ‎10-15-2017

Re: how to embed a response body/link into approval email

I've got that problem too. Somehow the flow was inserted in "For each" loop, maybe that was the problem.

How_do_I_get_into_my_data.png

 

I re-wrote the flow and now it works like a charm.

Level: Power Up
Posts: 3
Registered: ‎10-17-2017

Re: how to embed a response body/link into approval email

[ Edited ]

There is an easier workaround to send the user directly to the edit form, use a redirecting display form with some simple JavaScript: https://www.dmcinfo.com/latest-thinking/blog/id/8674/always-open-sharepoint-2013-tasks-in-edit-mode

I spent ages looking for a way to get the taskID so I could send the approver directly to the form but there is no way to do it, this is the best workaround i've seen.

Cheers, Anros

Cheers, Anros
Level: Powered On
Posts: 7
Registered: ‎10-16-2017

Re: how to embed a response body/link into approval email

This is great, thank you, Michael. Do you know if there is a way to extract direct link to actual submission. It looks like Response ID does not carry a link as an attribute

 

Thank you,

 

Kirill