How to filter choices() on Combobox

[JanLektonen]

I am not apple to filter Sharepoint data where the field is a lookup-field in a form.

Is it possible to filter like this:

Filter( Choices(ProjectTasks.Sprint); Project.Value="PROJ0112")

Unfortunately the above is not working when using FILTER.

If I do not use FILTER - it works but lists all data without filterering like: Choices(ProjectTasks.Sprint)

Please help me understand how to filter the new Combobox in a Form using the commando Choices(dbsource.field)

[jerrycrabb]

@CarlosFigueira   aha! never mind I figured it out.   What I needed was:

Filter(
     Choices('Attendee Registration'.DatesFirstChoice),
     Value in Filter(
          'Lookup Dates',
          Status.Value = "Registration Open"
     ).'Start Date'
)

[AnaAtlas]

Thanks!!!. this works for me

[jerrycrabb]

That's awesome, glad to hear it!