How to use Get group members from Azure Security groups BUT only if Account Status is Enabled

(1) Share

Report

Posted on by CU15081623-1

Hi All,

Wondering if anyone has a suggestion - after looking at raw output of get group members it doesn't seem to include Account Status so I can't easily apply an if statement.

Has anyone successfully managed to pull this data into a flow and use it to exclude disabled accounts?

Many thanks

Andrew

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Please share what you have already for future reference.

0. Generate an Array (to hold valid members)

1. You can grab the users from that list

2. Apply to each through the users

3. Call Get User profile v2 and get their status

If the status is Enabled, add them to your Array

Now you have a list.

Was this reply helpful? Yes No
CU15081623-1 4 on at

Like (0)

Report

Thanks @flmike :) and sorry for not sharing what i have - I already have an array, and successfully get all group members for the groups list in my excel spreadsheet in OneDrive and it then goes on to check their licences and produce a csv output for me - I just need to remove disabled azure accounts before the flow starts checking licences...

Assuming I grab the email address from the get group members and use that in the get user profile (v2) can you help me with the if statement to only include enabled accounts to proceed onto the next step?

Was this reply helpful? Yes No