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
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.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.