Unanswered

Cant get user Account status when implementing Get group members action from Azure AD.

(1) Share

Report

Posted on by SunilRangu

Can someone please help, I am working on a task to get memnbers list from Azure AD security group and email to a User. I can ble to generate a CSV report with Name, Email address and want to add additional column of user Account Status (Enabled/Disabled). I have used Get Group members in Azure AD to get the list and created CSV table to add columns of Name and Email address, but i couldn't see Account status field.

Is there a way i can get this information to add in to my CSV table?

I have used item()?['accountstatus'] as custom Expression and that didnt work.

Categories:

General topics

CSV Table.JPG

I have the same question (0)

All responses (3)

Answers (0)

sandeepstw 312 Moderator on at

Like (0)

Report

Hi There,

Create a variable grpMembersArray to hold data. Then use 'apply to each' on 'Get group members'. To get user Id use -

userId: "items('Apply_to_each')?['id']

Then use 'append array variable' action and in append to array put grpMemberArray. and put values like

Name: "@outputs('Get_user')?['body']?['displayName']
Email: "@outputs('Get_user')?['body']?['mail']
AccountStatus: "@if(equals(outputs('Get_user')?['body']?['accountEnabled'], true), 'Enabled', 'Disabled')

After 'apply to each' control use action 'Create CSV table' to convert array in csv.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
SunilRangu 2 on at

Like (1)

Report

Sorry I am totally lost, I am new to Power Automate and I dint quite understand the instructions. Is that okay if you can elaborate

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like (0)

Report

Hi,

for variable check this link - https://www.youtube.com/watch?v=6WrDNeGfT0I
apply to each - https://www.youtube.com/watch?v=d99Rr5djcME
for csv - https://www.youtube.com/watch?v=UzRe2T0ii8o&t=6s

Hope it all helps to understand what I given above.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No