cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lightswitch
New Member

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
Super User
Super User

Hello @Lightswitch 

 

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.

 

Jcook_0-1603918487828.png

 

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

2020-10-28_14-58-48.png

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

2 REPLIES 2
Jcook
Super User
Super User

Hello @Lightswitch 

 

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.

 

Jcook_0-1603918487828.png

 

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

2020-10-28_14-58-48.png

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,369)