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
Solved! Go to Solution.
Kรถnnten Sie es mit dem folgenden Ausdruck versuchen?
IN("ClockedIn", SELECT(Arbeitszeittabellen[ClockedIn], [Name]=USEREMAIL()))
Kรถnnten Sie es mit dem folgenden Ausdruck versuchen?
IN("ClockedIn", SELECT(Arbeitszeittabellen[ClockedIn], [Name]=USEREMAIL()))
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.
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |