You’re offline. This is a read only version of the page.
6
Hello all,
I have a few Power Apps based on Sharepoint Lists. Each app has an Admin table. If the current user is in the admin table I display a couple of extra menu items.
Share
ReportSet(
isUserAdmin,
!IsBlank(
LookUp(
TransportAdmins,
Admin.Email = currentUser.Email
)
)
);
What I would like to do is have one Admin list. There would be two columns, Name and App Name. Since a user could be an admin of more than one app I thought about trying to Filter the Admin table by the app name and do the LookUp all at once but I can't seem to get the syntax right, if it's even possible.
If anyone has any suggestions or other thoughts on how to do this it would be appreciated.
Thanks
Rob
Hi @RobGibson69 ,
I think this is not practical to compare with another admin list.
Assume that you have filled all app name and their admin user name in your admin list, then we need to compare the current app name with the data in your admin list. To get the current app name, we can use formula like:
All responses (
Answers (
PowerAppsforMakers.GetApp("Paste Your App ID HERE").properties.displayName​However, we need to specified the APP ID manually in above formula.
As a result, I would suggest you directly compare the current user name with your list(data source list he is accessing). So suggest you try formula like this：
Set(isUserAdmin, !IsBlank(LookUp(TransportAdmins,User().Email in Admin.Email)))
Best regards,
Allen
