Answered

Send email with pre-submitted Form Details when Planner Task is completed

(0) Share

Report

Posted on by Barking_Mad1

I can see how to send an email when a task is completed, but I also want to include some of the original MS Form details in the email from the completed task. I'm struggling how to do this, can anyone help?

Categories:

Building flows

All responses (11)

Answers (1)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Barking_Mad1 ,
please share the flow in Edit mode and also the error you’re getting, so that we could help you.

BR,
Marco
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I know it's wrong, ( the get response details wont allow me to pick the Form, ID) but this is what I have. I cant work out how to get the correct form ID details. Maybe I should get them from the Excel document? Any help appreciated....
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Barking_Mad1 ,
when you create the Planner task, are you storing also the Forms response Id?

BR,
Marco
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Marco,

Yes, because in the main flow where I handle it being received I can select it from the dynamic content.
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

ok @Barking_Mad1 ,
in your “Get response details” action you have to put the Reaponse Id” instead of the task Id.

BR,
Marco
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, that's the problem it doesn't appear anywhere in the dynamic list when I go to type it in. 😞 I've tried over a couple of days in case it was a PA issue, but no luck.
v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Barking_Mad1 ,

I guess you have two Flows, one to create a Planner Task based on the MS Forms' response, and the other to get the MS Forms' response details and send the mail when the task is complete. If so, you need to save the Response Id to the created Planner Task.

Flow 1:

I saved the Response Id to the Task's Title and used "-" as the delimiter.

Flow 2:

Extract Response Id from Title using expression.

last(split(triggerOutputs()?['body/title'],'-'))

Result Screenshot:

Best Regards,
Charlie Choi
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for the reply and sorry for the delay in getting back to you.

I think this will work, the only issue I have is that the flow that creates the task, creates different planner tasks depending on the details entered in the MS Form. However thankfully all the 'Create a Task' options do so with the same Title (so I think this should be ok?):

'First Name' 'Surname' | 'Programme' | 'Cohort' - 'Response ID'

(they are divided by the '|' symbol)

However I'm not sure how I amend this in regard to the expression you wrote out below, any chance you could advise?

last(split(triggerOutputs()?['body/title'],'-'))
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Barking_Mad1 ,

Based on the sample title you provided, this expression should work.

In addition, you could try nesting a replace() function on the original expression to remove extra spaces.

replace(last(split(triggerOutputs()?['body/title'],'-')),' ','')

Best Regards,
Charlie Choi
Barking_Mad1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for the help, that is working perfectly!