Setting Variable based on boolean field Sharepoint List

(0) Share

Report

Posted on by senna

191

Hello,

I have a sharepoint list with a yes/no field called "SpBooleanField", i'm trying to check the user exists as an employee on the list and that the field SpBooleanField is set to true (Yes in sharepoint). I cannot understand why the below is not working, any help would be really appreciated.

Set(
 varIsRequired,
 !IsBlank(
 LookUp(
 myList,
 And(employee.Email = LoginUser.Email && SpBooleanField=true )
 )
 )
);

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
Set( varIsRequired, !IsBlank( LookUp( myList, And(employee.Email = User().Email && SpBooleanField) ) ) );

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@CiaranCampbell

Try this and see if it works.

Set( varIsRequired, !IsBlank( LookUp( myList, And(employee.Email = LoginUser.Email && SpBooleanField) ) ) )

Was this reply helpful? Yes No
senna 191 on at

Like (0)

Report

unfortunately the loginuser isn't the issue, i just store the user details on start but have tried it with User() and same issue

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

For a test, please add SpBooleanField to a label and show me the output?

Was this reply helpful? Yes No
senna 191 on at

Like (0)

Report

unfortunately that doesn't work. I also tried !IsBlank(SpBlleanField) and same issue

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

For a test, please add SpBooleanField to a label and show me the output?

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
@CiaranCampbell try this:

Set( varIsRequired, !IsBlank( LookUp( myList, And(employee.Email = LoginUser.Email && SpBooleanField=1 ) ) ) );

Was this reply helpful? Yes No
senna 191 on at

Like (0)

Report

@phipps0218
Thanks, those aren't the actual names, its is set onSelect of a button, here is the real code;
The label code

the actual label result when run

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (1)

Report

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/158375

Was this reply helpful? Yes No