Power Platform Community Forum Thread Details

Hello,

I know this has been asked before but I'm really struggling to write my formula to check two conditions before evaluating to true or false. I understand that you need to nest them somehow because the formula will not complete any other steps once it recognizes a statement as true but I can't figure out how to write the formula. I have three buttons on my load screen for one of my apps(User, Manager and Read Only buttons). For the User button, I have a list of users in a SharePoint list that I use to determine whether this button/screen should be visible to the current user.

The formula for that is:

IsBlank(
LookUp(
CollectorMasterList,
Title = CurrentUserName
).Title
)

The formula for my Read-only button uses Flow, SharePoint Groups and variables to determine if this button should be visible. The formula for that is:

If(
OpsFinUser.isopsfinuser = "True",
true,
false
)

What I cannot seem to figure out is how do I create a formula for my 3rd button that says: If the current user is not in the user master list and isopsfinuser = "false" then the visible property on my 3rd button is = "true".

Currently in my attempt to nest the conditions my formula is a mess and looks like this:

IsBlank(LookUp(CollectorMasterList, Title), And(Title = CurrentUserName).Title),OpsFinUser.isadminuser = "false"), "true");

Thanks for any help!

@wyotim

Categories:

Building Power Apps