cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jja
Post Prodigy
Post Prodigy

Filter drop down suggestions

Hi

I see on some of model driven app tables some columns when filtering the data is seen in a drop down others ask to enter text

on what it depens? I understand if i have a choice column it will be drop down and what about others?

Like for example here i have a drop down if i move to the search field - column type is lookup:

jja_0-1648639821392.png

 

Here column type is text and it will not allow the drop down proposal on search field. Is it possible to change the behaviour so it also drops down and i can search by fragment of the column value?

jja_1-1648639935928.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hello @jja 

 

You can use CONTAINS operator which can be used for all the Options(Drop Down/lookup/text field)

 

Hope it helps, else can you please brief your previous question.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

4 REPLIES 4
rampprakash
Super User
Super User

Hello @jja 

 

As per OOB Behavior we cannot change the existing behavior, Both Choice and Lookup will show as a DROP DOWN option, for Text we need to manually enter text( you can use CONTAINS operator to filter in a better way)

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

jja
Post Prodigy
Post Prodigy

@rampprakash 

But if user demand also a drop down or something where they type and if data exists it starts showing in the search field what would you do in this case with a workaround?

Hello @jja 

 

You can use CONTAINS operator which can be used for all the Options(Drop Down/lookup/text field)

 

Hope it helps, else can you please brief your previous question.

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

@rampprakash 

Yes CONTAINS works but i also implemented standard dataverse search and in the search box he can search by this fragment. This is also very attractive for end users

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!

Users online (3,352)