Solved: Re: Choices with "contains value"

THowkins96 · ‎09-26-2022

Hi all,

I am looking to amend my choices formula to allow the user to type in values that are contained within the data source. I.E if I am searching for "Apples, Bananas, Pears" currently I would have to start typing with "Apples" whereas I want the option to come up should I decided to start typing with "Banana".

My current formula in Items is: Choices(DataSource.Column)

Thanks

Tom

THowkins96 · ‎09-27-2022

Hi @BCBuizer

I managed to figure it out, what I was missing was the Filter function around the choices. I ended up with the below:

Items = Filter(Choices(Recruitment.'Site Name'), Value)

View solution in original post

BCBuizer · ‎09-26-2022

Hi @THowkins96,

You formula seems correct. Can you please share a bit more about the context in which you are working and what it is you are running into?

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

THowkins96 · ‎09-27-2022

Hi @BCBuizer

I managed to figure it out, what I was missing was the Filter function around the choices. I ended up with the below:

Items = Filter(Choices(Recruitment.'Site Name'), Value)

Choices with "contains value"

Helpful resources

Power Apps News & Announcements

Introducing the Community Calls Conversations

Power Apps Community Blog