Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Dropdown filter from lookup field



I´m trying to filter a dropdown base on a second field on the same lookup table.


These are my cotrols:

Data Source: Solicitudes

Combo Box Name:cboColaboradores


Items properties: Choices(Solicitudes.Colaboradores)  --This shows a name list from a Sharepoint Lookup Field.


This lookup fied has another field name Colaborador_x003a_status with values like A(Active) and I(Inactive)


I tried to filter by these Status.


Filter(Choices(Solicitudes.Colaboradores),Colaborador_x003a_Status.Value =  "A")  ---- result=nothing


also tried:

Filter(Choices(Solicitudes.Colaboradores),Colaborador_x003a_Status =  "A")  -- but says "Invalid argument type"


if i test the Status values using Choices(Colaborador_x003a_Status) it shows theses values, meaning the values are there


it is the type?


What i´m missing?


Thanx in advance!



Thank you.  That was a great help.

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,634)