List from a selected enumlist values

ATR
Bronze 5
Bronze 5

I’m trying to get a list based on selected ref enumlist. I’ve tried this formula but it didn’t return anythig.

SELECT(
Requisições[Proposta],
IN(Requisições[Requisição], [_THISROW].[Requisições]),
TRUE
)

I want to get the values from “Proposta” column at “Requisições” table that matches with the selected “Requisições” enumlist ref from “Requisições” table. The form is at another table called “Cobrança” that has “Requisições” Column (that is a Enumlist with ref to Requisições table) and it has a “Proposta” column that should return what i said before

Solved Solved
0 9 1,909
1 ACCEPTED SOLUTION

@Marc_Dillon Wouldn’t a list-dereference work better here? It would certainly be more efficient.


Your original formula:

SELECT(
Requisições[Proposta],
IN(Requisições[Requisição], [_THISROW].[Requisições]),
TRUE
)

could be simplified to

UNIQUE([Requisições][Proposta])

View solution in original post

9 REPLIES 9
Top Labels in this Space