cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joeljohn
Frequent Visitor

Dropdown filter from lookup field

Hi!

 

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!

 

10 REPLIES 10

Thank you.  That was a great help.

Helpful resources

Announcements
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)