Hello all !
I am newbie to Forms / PowerAutomate and I want to "pump up" a form + flow that I created, to be able to send an email to one or multiple / Assign a task to one or multiple based on a form question that allows multiple answers.
My setup is the following :
- The form gathers the answers
- In the form there's a question about "What department is your request about".
Answer can be multiple as a request can be towards more than one department ( 1 to n )
- After creating the Item in a Sharepoint List, I want to Send an Email and Create a Task in Planner.
Sending the email to one "default" person or creating the Task in planner is easy (Thanks to previous forum Q&A 😀)
What I am looking for is to send the email to / assign the planner Task to certain people, depending on the answers provided to the "What department is your request about" answer(s).
- I think I need to do a mapping table to have a matching list between department and recipients
Dept A - user1 email
Dept B - user2 email
Dept C - user3 email
... and so on
- Then I think I need create a temp string which will concatenate the emails
If "form_dept_question_value" contains "Dept A" then "Append to" temp string "user1 email"
If "form_dept_question_value" contains "Dept B" then "Append to" temp string "user2 email"
If "form_dept_question_value" contains "Dept C" then "Append to" temp string "user3 email"
Next step will be to use the "temp string" content and use it when creating the email and the Planner Task.
This seems the easiest step (assuming I will find easily the temp string system ID 🤣 )
I would need support / advice on how to do this in the most easy way
I am a indeed bit clueless on which steps / features / commands I need to use ... Support & advices would be greatly appreciated !
