Exporting Ad Security Groups + Members/email/dept for CSV

(0) Share

Report

Posted on by 6110VI

Hello and thank in advance for any advice offered.

I have a non-microsoft product that doesn't have any direct way to read AD/LDAP data, and I'd like to be able to produce a table of users + department / email and their associated AD security groups to double check where incorrect are applied/missing etc.

Based on this example - I'd like to ( hopefully as simply as possible ) extract AD Security groups + members ( with user/email/department/title and as a bonus reports in/out)
https://powerusers.microsoft.com/t5/Building-Flows/Creating-a-list-of-Azure-AD-users-as-a-CSV-Excel-file/td-p/1476733

Is this a difficult thing to achieve in flows ? I guess I'd want groups first , then users in groups, then ALL users , to then allow for users that don't have groups to be included in results too.