Unanswered

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

I have the same question (0)

All responses (11)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Barking_Mad1 on at

Like (0)

Report

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....

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

BR,
Marco

Was this reply helpful? Yes No
Barking_Mad1 on at

Like (0)

Report

Hi Marco,

Yes, because in the main flow where I handle it being received I can select it from the dynamic content.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

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

BR,
Marco

Was this reply helpful? Yes No
Barking_Mad1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Barking_Mad1 on at

Like (0)

Report

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'],'-'))

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Barking_Mad1 on at

Like (0)

Report

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

Was this reply helpful? Yes No