News and Announcements icon

Power Platform CommunityForums Power Apps - Power Query Active Directory query...

Power Apps - Power Query

Unanswered

Active Directory query group membership for a user

(0) Share

Report

Report

Posted on by brianw

I would like to use Power Query (within Excel) to interrogate Active Directory.

Given a list of userids in a worksheet, is it possible to lookup each one in AD and test whether they are a member of a specific group?

All responses Img

All responses (1)

Answers Img

Answers (0)

DR279 2 on at

Like (0)

Report

Active Directory query group membership for a user

I would also like to know how to do this. We have over 100k AD groups in our company. Loading all of them to be able to confirm which AD groups a person is in takes a long time.

Also, why is this post marked as "Answered"?

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

WarrenBelz 143,867

#2

RandyHayes 76,308

#3

Pstork1 64,174

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans