Filter drop down suggestions

[jja]

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:

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?

[rampprakash]

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]

@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?

[rampprakash · Accepted solution]

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

[jja]

@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