You’re offline. This is a read only version of the page.
Hello!
Hoping for some help with a scenario I've got and described below...
1. In Form, user completes form and can select 1 or 19 options from a multiple choice question & submits (each answer represents a department, and each department has 3 people associated to it.)
2. Flow then sends approval to designated people from each answer selected. For example, if A and E are selected in the form, the approval must go to the people associated to department A and E.
I'm guessing the best way to do this may be a SharePoint list which has each persons email listed in one column and the department they belong to in another, for example
Josh | Department A
John | Department B
Mark| Department C
Sarah| Department D
Steve| Department E
So in the case mentioned above, Josh and Steve would be sent the approval request.
But in my actual scenario there is 19 departments and about 3 different people per department.
Any help or guidance on how to build a flow a flow to work like this would be greatly appreciated 🙂
Thanks,
Josh
Hi
Can someone give me some guidance, I'm looking to create a start and wait for approval with the email address being fed from a multiple choice field in the form but im having the below error
@Mira_Ghaly - positive update!
I got the expression to work and ran a test - all seems to be working 😄
I'm going to run a few more tests, most likely tomorrow, with all 19 options in the SharePoint list.
I really appreciate your help - thank you!
I've updated as per your screenshots and tested a run but ran into an issue. I think it may be related to the expression for the Answers array...
This what I used:
I really appreciate your patience in helping me, hopefully will get there soon!
Thank you,
Josh
Sorry if I have confused you please follow the sample below i have tried to replicated your scenario as below:
1. Initialize 2 variables answers and emails array , answers should hold the response from the microsoft form response
Expression for the Answers array:
Share
Report
All responses (
Answers (
split(replace(replace(replace(outputs('Get_response_details')?['body/r8a667099fbd94265925bad11cf7da507'],'[',''),']',''),'"',''),',')Please note that you need to replace with the response from your form:
outputs('Get_response_details')?['body/r8a667099fbd94265925bad11cf7da507']
2. Loop on the answers array to get the approver list per each partner
3. Then loop on the approvers to append emails
4. Send approval outside loop
So i tried moving the start and wait for approval outside the loop however it is not failing. Here is the error:
"Let's go one step back you need to split the multiple choice response then you can Get items on each of the options and do the existing logic." - apologies I'm not sure what you mean / how to do this?
Let's go one step back you need to split the multiple choice response then you can Get items on each of the options and do the existing logic.
The problem now is the Get Items is returning data, what is the column type of partner in SharePoint?
Ah right I see - I've updated the OData to include the dynamic content from the form response.
In the example I submitted, I selected 2 choices from the 19 on the form, which in the run history has pulled through correctly on the get items, however the send and wait for approval has not gone to the users.
The run history is showing the apply to each steps greyed out but with no errors, so i'm not sure what is going on
I believe the issue is here in the OData from where you are getting the partner .. is it from the form response?
Then you should pass it , can you check the flow run history to see the steps execution and where it get stuck?
#1
stampcoin
61
#2
Michael E. Gernaey
47
Super User 2025 Season 1
#3
rzaneti
31
Super User 2025 Season 1
