Is there a quick/straightforward way in Power Automate to take a top level distribution group, and pull (recursively) all the nested distribution groups?
i.e., I have a TL disto: SiteDistro.
SiteDistro
--Divsion1
----D1Branch1
----D1Branch2
----D1Branch3
----etc
--Divsion2
----D2Branch1
----D2Branch2
----D2Branch3
----etc
--etc
Is there a way I can feed it the name of the top level distro and get back all the division and branch distros (and any other distros people might have stuck in there)?
Second question is then: I have a spreadsheet with a list of all users. I have created a flow that will go through the list and pull their distros based off their email. I suspect it's just then a select statement (of some sort) to see if "Does <#user's list of distros> include one or more of <hierarchy of distros>", but I'm not sure if there's a faster way.
Right now, the part that pulls the distros seems painfully slow (compared to how fast it would be in Powershell, which, alas, I don't have in this system), even with using a compose to build the list of distros for the user, and having concurrency cranked.

Report
All responses (
Answers (