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!

[ypurcaro]

Hello,

I have something similar to this but all I need is to display a dropdown menu on the edit form so user can choose either yes or no. I have a list on the sharepoint and the column named "Decline" was set as Choice with Dropdown menu. (Choices are yes, no). In my case, I don't need filter, correct? Any helps is appreciated. Thank you.

[jv123]

Carlos,

Can you provide an example of this?