Check if user is existing in the SharePoint group or not.

(0) Share

Report

Posted on by VenkataKishore

Hi,

I am new to power apps. I have a below scenario.

List 1

Title	Groups(people picker column)
Title1	Group A; Group B
Title2	Group C

List 2

Title	EmpName(People picker column)

I am building a form for the List 2.
When I enter Title value and user name in the 'EmpName' column and click on submit button. I have to query the List 1 based on the entered Title value and check the user belongs to SharePoint groups, Group A or Group B or Group C

I am able to filter the List 1 based on the Title value and get the groups. But I am not able find method or solution to check whether the user is belongs to which group.

Can you please help me in providing the solution for this.

Thanks,
Kishore.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VenkataKishore ,

I have a blog on SharePoint Group membership that may assist.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
VenkataKishore 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thanks for your reply. I have tried your solution
Office365Groups.ListOwnedGroups().value
I am getting empty for the above code.

For your information, the SharePoint groups are created manually at the SharePoint site level.
Can you please let me know if you have any ideas to overcome this scenario.

Thanks,
Kishore.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @VenkataKishore ,

We are talking about different Groups here - my blog was on Office365 Security Groups. I have never done it, but here is a tutorial that seems to explain the process.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
VenkataKishore 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz , I will use the Power automate for this.

Regards,
Kishore.

Was this reply helpful? Yes No
Mpalomares 7 on at

Like
a
(0)

Report
Copy link

Link copied!

This approach still used O365 groups and not SharePoint groups

Was this reply helpful? Yes No