web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Fetch members from nes...

Power Apps

Unanswered

Fetch members from nested Security Groups in PowerApps

(0) Share

Report

Report

Posted on by Kulshreshtha Microsoft Employee

We have a requirement to restrict user access to certain pages within PowerApps.

The users are part of various security groups which again are part of a single SG.

Thus, there are multiple layers of Security Groups we need to access to get the user data.

Currently, we are accessing the SGs using nested ForAll loops in the OnStart property as below.

This is an intensive operation and hence the app takes approx. 2 min to load.

Is there a way to enhance the performance of the app?

Thanks in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

FabianAckeret 975 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kulshreshtha

I assume your data source is SharePoint? Unfortunately, Power Apps isn't very great when it comes to security settings with SharePoint. If you have individual permission requirements, this can get difficult.
If possible it would probably best to use Dataverse as a data source. You have much better security options/control.

If above is not an option, you could try to change your formula. Do you really need to loop through all of them? Can't you simply check if the user is part of a specific group? Like so:
!IsEmpty( Filter( Office365Groups.ListGroupMembers( "<group Id>" ).value, mail = User().Email ) ) || !IsEmpty( Filter( Office365Groups.ListOwnedGroupsV2().value, id = "<group Id>" ) )

Also, if you indeed need to loop through them, I realized you're using the same command a few times.
I would recommmend you to look into the With() function. Perhaps this could speed things up a bit.

Sorry for not being a better help...
FabianAckeret 975 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kulshreshtha

Did my answer help you out? If so, it would be great if you could accept it as a solution.

Thanks and kind regards,

Join the conversation