Putting SharePoint row values into variables

(0) Share

Report

Posted on by Iamglt

316

Hi,

I have a table that has a list of users, emails and parts of the app they are allowed to have access to:

What I am trying to do is on App Start, search this table and if my username matches an entry, then if HRAccess, SecurityAccess and AdminAccess are yes then the end user will have access to those screens which have a 'Yes' marked on them. I have the following collection:

ClearCollect(
 varAccessCheck,
 Sort(
 NewEmployeeAccess,
 ID,
 Descending
 )
);
Set(varEmail,First(Filter(varAccessCheck,'EmailAddress');
Set(varHR,First(Filter(varAccessCheck,'HRAccess');
Set(varAdmin,First(Filter(varAccessCheck,'AdminAccess')

Can anyone advise why my code is not working and if I should create global variables as above, then reference them across my screens in my app or if I should create a collection at each screen and check there? Please note that using Office365 groups to control screen access is not an option here.

Cheers,

Geoff.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

@Iamglt

I suggest you use LookUp.

ClearCollect(
    varAccessCheck,
    Sort(
        NewEmployeeAccess,
        ID,
        Descending
    )
);
Set(varMail,User().Email);
Set(varHR,LookUp( varAccessCheck,EmailAddress=varMail,HRAccess));
Set(varAdmin,LookUp( varAccessCheck,EmailAddress=varMail,AdminAccess));
Set(varSecurity,LookUp( varAccessCheck,EmailAddress=varMail, SecurityAccess));

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.