Hide view

[Ron-van-Bergen]

Hello all,

I want to hide a view if two conditions are true.

1- Useremail() is present in table field "Name"

2- Value in table field "ClockedIn" is true

I have the following code, but it doesn't work,

NOT(AND(CONTAINS(Timesheet[Name],TEXT(USEREMAIL())),CONTAINS(Timesheet[ClockedIn],true)))

I hope someone can help me in the richt direction.

Thanks in advance

[Tommy62 · Accepted solution]

Könnten Sie es mit dem folgenden Ausdruck versuchen?

IN("ClockedIn", SELECT(Arbeitszeittabellen[ClockedIn], [Name]=USEREMAIL()))

[Ron-van-Bergen]

Hello Tommy,

Thanks for your direction it helped me a lot,

Your code pointed me in the right direction

The working code to hide the view is.

not(Contains(SELECT(Timesheet[ClockedIn],[Name]=USEREMAIL()),True))

Thanks a lot.