cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanLektonen
Advocate III
Advocate III

How to filter choices() on Combobox

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)

24 REPLIES 24

@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
New Member

Thanks!!!. this works for me

That's awesome, glad to hear it!

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.

Carlos,

Can you provide an example of this?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,949)