
Hi,
I have a MS Form which users complete and then click submit.
From there, I am building a Power Automate Flow to send it for Approval, but I want it to only be sent to Approvers from the same Department as the Sender. The list of Approvers are stored in an Active Directory Group. So when the flow runs, is it possible to get the Department of the Sender (user is authenticated via AD) and match it with Approvers in an AD Group who have the same Department as the Sender?
At the moment I have the flow set to
1) When a new response is submitted - Form Id is my form
2) Get Response details - Form Id is my form and Response id is Response id
3) Start and wait for an Approval - I feel this is where I need to add some logic in the Assigned To field on the paramatars tab or perhaps some conditions beforehand, but not sure how to go about doing this.
Any ideas on how to do this? any help appreciated.
Thank you
Please see below that I have found in this forum.
Hoefully the above matches in some way what you wanted. But I do not think it got solved. Please note I have not used the above but have understood the general gist of the flow.
Please let me know how you get on.
Regards,
Andrew