Share
Report
56Hi all,
I know this is asked many times and I have read them but I think mine is a little different (probably easier I just can't seem to work it out).
So I have a change request library where a user fills in a standard SP list item and submits. On submit, I need to run a 2 level approval process.
The first level is fine - it's the owner of a template the user selects in the change request and it's always a single person and I can get that easily enough in my flow and assign an approval them. Works great.
The 2nd level is where I am asking for assistance on the best way to go about it.
Basically the 2nd level approval(s) have to go to about 14 different studio groups. Each of the studios can have 2-4 approvers in it and I only need 1 of them to approve/reject.
Now I have done it before where I can get the members of an SP group, append their emails, assign them the approval task.... but do would I have to then create 14 SP groups and then do 14 Send HTTP requests to get each set and assign to variables?
I read up on the topic and saw the use of a SharePoint list to house the approvers... Ok I made a list called Approvers, one column called Studio and one called Approvers (people picker, allow multiple persons is set to Yes)
But again to get each studio group of approvers into a variable that I can then assign an approval task to, do I have to do a Get Items 14 times specifying the ID each time? This was the way I saw being done here - https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Get-Approvers-Dynamically-from-SharePoint-List/ba-p/169357#:~:text=The%20first%20step%20is%20to,if%20you%20need%20multiple%20approvers.
This is what I see all other threads doing it seems - there is some ID you use, or some other column like Department or Country that is specified in the original trigger....which I don't really have...….I just need to be able to pull the 14 studio groups - get their approvers listed and assign them an approval for every single submission.
Oh and to have the 14 studios all get their approvals all at once it would be parallel? Don't need them to have to wait on each other - after the first approval we are basically giving each studio their chance to approve/reject the request but it needs to be concurrent.
Looking for ideas on how to do this effectively as for some reason I can't seem to get my head around it other than to do a Get Items 14 times...I am probably missing some super easy but it's just isn't getting through my thick skull 😄
Any ideas/help is, as always, appreciated!
Thanks!
All responses (
Answers (
