Slice table based on ENUMLIST but ANY results into one

AppSheet AppSheet Q&A
,
1

Dear Community,

I stuck somewhere around where a user have an access to 3 Locations (as ENUMLIST) in the user master,

I need to slice the Data Table with the locations when that particular user logged in…

User Name is a reference USER Master Table

[USER Name].[Locations] = { “Location1” , “Location2” , “Location3” }

Slicing :

And([USER Name].[Email]=User e mail(), Any([Location]=[USER Name].[Locations]))

Please suggest…Thanks in advance…

2

Probiere:

Contains(LOOKUP(USEREMAIL(),"Standort1","Standort2","Standort3"),[E-Mail])
1 Like
3

This Way ?

Contains(LOOKUP(USEREMAIL(),"User_Master","E-Mail","Locations"),[Location])
1 Like
4

Ich zeige Ihnen den Lösungsweg und Sie markieren Ihre als Lösung???

1 Like