Answered

Or statement not working

(0) Share

Report

Posted on by Dorinda

1,512

I have a checkbox that when clicked opens a popup. The issue is I need it to look at the current user signed in and compare that user to the Safety Group to ensure that only those people who are listed have the ability to check the box.

I have it working for just the Scribe to be able to check that box but I also need the ChairPerson to be able to check it as well.

I do not know how to modify the code below to be an OR so either one can check the box

UpdateContext(
 {
 lclPopUp: If(
 Or(DataCardValue45_2.Selected.DisplayName = CurrentUser.FullName,Or(DataCardValue56_2.Selected.DisplayName = CurrentUser.FullName,LookUp(SafetyMeetingGroups_1,Lower(Scribe.Email)=Lower(CurrentUser.Email)).ID>0)),
 "Trainer"
 )
 }
);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
HI @Dorinda ,

There is nothing much wrong with your code - slightly modified below to allow for Delegation, and slightly different syntax, but this would produce a Text Variable "Trainer" if both statements were true.

UpdateContext( { lclPopUp: If( DataCardValue45_2.Selected.DisplayName = CurrentUser.FullName || ( DataCardValue56_2.Selected.DisplayName = CurrentUser.FullName && LookUp( SafetyMeetingGroups_1, StartsWith( Scribe.Email, CurrentUser.Email ) ).ID > 0 ), "Trainer" ) } )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report
Copy link

Link copied!

That is only covering if it is the Scribe how do i account for the ChairPerson?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Dorinda ,

Assuming a field name here

UpdateContext( { lclPopUp: If( DataCardValue45_2.Selected.DisplayName = CurrentUser.FullName || ( DataCardValue56_2.Selected.DisplayName = CurrentUser.FullName && LookUp( SafetyMeetingGroups_1, StartsWith( Scribe.Email, CurrentUser.Email ) || StartsWith( Chairperson.Email, CurrentUser.Email ) ).ID > 0 ), "Trainer" ) } )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like (0)

Report
Copy link

Link copied!

Thank you!! works perfect

Was this reply helpful? Yes No