Dropdown from valid_if

[limyongsheng]

Hello all, am having trouble following along with Section 3 from below:

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

I am trying to create a dropdown of usernames with a specific role using the valid_if constraint.

This is the formula entered in valid_if:

SELECT(Users[Name], [Role]="Requestor")

The formula is valid, but there are no results returned.

The Requests table and Users table are not linked (screenshots below)

[Suvrutt_Gurjar]

Is the Valid_if expression returning any values when you tap on "test" under the Valid_If expression setting?

[limyongsheng]

No, the expression result is blank (although valid)

[Suvrutt_Gurjar]

So you could debug it in steps. Does Users[Name] return any results?