I have multiple units at my org and each org has their own SharePoint list where we track their tasks. I am trying to figure out if it's possible to create a flow that will take information from a single Microsoft Form and then use that to add a task to the appropriate unit's list. Any help is appreciated.
Using one Microsoft Form to update one of multiple SharePoint Lists
Hello,
it is definitely possible, but it depends on the structure of your Form. For example, you could just add a Question to the Form "Which Business Unit are you located in?" as a selection field, Unit 1, Unit 2, Unit 3,...
In your Power Automate Flow, you just start with the trigger When a new Response is submitted and follow with Get Response Details. Then I would use a Switch with the dynamic Content of the Question "Which Business Unit are you located in?". Each Case would then be equal to Unit 1, Unit 2 and so on. In each case you could continue to build your flow to create new Tasks with the Details of the Form.
Hope the answer is helpful!
Best reagrds,
Leander
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.