Disable button for every user except for the one(s) a filtered list outputs – works only if there's just one

1

Dear community,

I need your help again:

I use this formula to disable a button:

user().In(Filter(db_ROLLEN, RoleID = “6”).[Hold by]).Not()

So if the current user is NOT part of this list, the button is disabled. This works great, but only as long as only one user is assigned to this role. If there are severals, the “in” function never finds them.

I’ve tried this workaround which does not help:

user().ToText().In(Filter(db_ROLLEN, RoleID = “6”).[Hold by].ToText()).Not()

Any other idea?

Thanks a lot for your help,

Jann

2

I’m afraid there’s a lot of ambiguity in your post, a complete shot in the dark would be to throw in a listcombine like this:

user().In(Filter(db_ROLLEN, RoleID = “6”).[Hold by].ListCombine()).Not()

I would also suggest flipping the formula to make it a bit more intuitive

db_ROLLEN.Filter(RoleID="6").[Hold by].ListCombine().Contains(user()).Not()

Please make a dummy doc to give us a better chance of helping you

3

Hi Rickard,

thx a lot for your answer, this actually works perfectly!

Have a great day,

Jann