Answered

Forms to Planner: Assign task to user(s) based on form response(s)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a Microsoft Form configured to feed responses into Microsoft Planner, using Power Automate. This automatically creates a task in Planner and assigns it to a user.

However, I want the task to be assigned to users based on the answers provided in the form.

For example:

If form answer = yes, assign task to user Bob
If form answer = no, assign task to user Dan

Is this possible using Power Automate? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @Anonymous

Yes of course, here is a POC:

First Initialize a String Variable,

Next add a Condition, put in your MS forms Question on the left, is equal to, Yes

Now on the If yes, add a 'Set Variable' action and put in the Email you want to assign to if the answer is Yes.

Do the same thing in the If no block, Set that variable to the Email you want to assign is the question is No.

Now you can use the Variable dynamic content inside your Planner action to assign the task.

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

Like (0)

Report
Copy link

Link copied!

How would you apply this to multiple questions or questions with more than two responses? Say I wanted to assign the Planner task out to a location based team. Form has a drop down with 6 options: North America, South America, Europe, Africa, Asia, Australia. Each continent needs to be assigned to a different user. Can I modify the two user scenario solution you shared to make this work?

Was this reply helpful? Yes No
tarnhart 6 on at

Like (0)

Report
Copy link

Link copied!

You would use a switch control.

Was this reply helpful? Yes No