Unanswered

using 365 groups to hide and show a button

(0) Share

Report

Posted on by help3

Hi,

I have created a few buttons and i want to hide them, based on the 365 groups the user are in. I have tested both these Fx on the visible setting of the button. It looks like its working because it hiding them from me. but when i add myself to the group it still does not show up for me.

I don't get any errors. I have added the Office365group connecter as well.

If(CountRows(Filter(Office365Groups.ListGroupMembers("ID_is here").value, mail = User().Email))
<> 0,

true,
false)

or this one

!IsEmpty(Filter(Office365Groups.ListGroupMembers("idishere").value,mail=User().FullName))

but if i user this it works and show the button.

If(
User().FullName = "" ||
User().FullName = "" ||
User().FullName = "",
true,
false
)

so i thinking it might be something to do with the groups.

Kind Regards

Categories:

Connecting to Data

General Questions

Using Apps Using Formulas

All responses (2)

Answers (0)

help3 on at

Like (0)

Report

Re: using 365 groups to hide and show a button

fixed it
!IsEmpty(Filter(Office365Groups.ListGroupMembers("ID").value,Lower(mail)= Lower(User().Email)))
help3 on at

Like (0)

Report

Re: using 365 groups to hide and show a button

I think i know the problem, is there a way to user this Fx below.
i did a test and my E-mail is coming out as TEst@company.com but i need to convert it down to test@compay.com

i tried this

!IsEmpty(Filter(Office365Groups.ListGroupMembers("ID").value,mail= Lower(User().Email)))

but it did not work, not sure if I'm doing it right.

Kind Regards