Column Disappearing when comparing

[Aldrin_Nyamweda]

I have figured it out BUT it’s working when I hardcode the value of the Email, but i don’t want that. Instead, I want it to pick the email from a list.

Here’s my problem code:
IFS(

Useremail() = ANY(Select(SystemUsers[User 1],TRUE)), Select(Files[Content 1],TRUE)
,
Useremail() = ANY(Select(SystemUsers[User 2],TRUE)), Select(Files[Content 2],TRUE)
)

The bold part is where the issue is

This is the code that is working (But I don’t want this because it involves hardcoding):
IFS(

Useremail() = “josh@email.com”, Select(Files[Content 1],TRUE)
,
Useremail() = “sara@email.com”, Select(Files[Content 2],TRUE)

)

Please help in any way you can.

[Marc_Dillon · Accepted solution]

Aldrin_Nyamweda:

ANY(Select(SystemUsers[User 1],TRUE))

What is “SystemUsers”? a Slice or a Table? How many records are in it? Are you aware that ANY() just takes the first item in a List? What does this portion of the expression return when evaluated by itself?

SELECT( Table[column] , TRUE )

is exactly equivalent to simply:

Table[column]

help.appsheet.com

ANY()

One arbitrary list item

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Aldrin_Nyamweda]

Hi Marc

Oh my Lord, You are a genius. I checked what it was returning and it was not returning anything. And then I checked the key of the record and realized it was empty. The Name field is the Key and the Label as well.

Change the name field to Text and put a key and voila! my columns returned

Thank you so much for that.