You’re offline. This is a read only version of the page.
151
I have this sharepoint list called FCIIA:
The Column AreaDD is a Choices column with allowed multiple selection.
This list will contain people names and unique Glogin which is their ID.
I want people to be able to only see areas on a galleryview which are based on the AreaDD, so this TEST person should be able to see all records that have are KYC and Sanction in the gallery view.
I was trying to write something like this but not working
OnStart:
Set(gblLoggedUserID,Office365Users.MyProfileV2().mailNickname); THIS LINE WORKS
Set(vUserGroup, Filter(FCIIA, Glogin = gblLoggedUserID).AreaDD); THIS LINE DOES NOT WORK
in the gallery view i want to then filter on the vUserGroup so that it only shows records where Area is equal to the logged in user.
Can you help me out ?
Hi @Wolfmeyn ,
Try this instead - Filter will get a record - LookUp (as below) get as single field value
Share
Report
All responses (
Answers (
Set(
vUserGroup,
LookUp(
FCIIA,
Glogin = gblLoggedUserID
).AreaDD
);
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.
MVP (Business Applications) Visit my blog Practical Power Apps
