Unanswered

Searching in a Lookup View

(0) Share

Report

Posted on by hantsjoel

I have a ootb n:n relationship between a table called FOI Tracker and a table called FOI - Exemptions. My main form for FOI Tracker contains a subgrid of related FOI - Exemptions, so that the user can select relevant Exemptions for that record.

I'm having trouble with the search functionality in the Lookup View of the FOI - Exemptions table. Ideally I'd like the search function to do a full text search of two columns - 'Name' and 'Exemption Number'. I have added these two columns to the Find by section of the Lookup View:

However, when I use the view, search will work for the start of the Exemption Number string, e.g.

But I cannot search by a substring of the Exemption Number, or any part of the Name column, e.g.

What's more, pressing Enter to browse all records returns nothing:

Have I configured this incorrectly? Is what I am trying to achieve possible?

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

gulshankhurana 1,397 Moderator on at

Like (1)

Report

Hi @hantsjoel

Please could you check if the fields/columns you want to search with have been made searchable under 'Find Columns' in 'Quick Find View' of the table.

Kind regards
Gulshan

Please give it a Thumbs Up if you appreciate my efforts and if my reply helps you resolve your issue then please accept it as a solution.

Was this reply helpful? Yes No
hantsjoel 96 on at

Like (0)

Report

Hi @gulshankhurana, thank you for the suggestion. Only one column was selected in the Quick Find View, so I have added the second and I can now search for Exemptions by the Name field.

Do you have any suggestions how I might be able to search a substring of both these fields? E.g. The Exemption Number field contains values such as 'Section 12', 'Section 13', 'Regulation 12(4)(a)'. It would be great to be able to search with the term '12' and have the rows containing 12 appear in the results.

Thank you!

Was this reply helpful? Yes No
gulshankhurana 1,397 Moderator on at

Like (1)

Report

Hi @hantsjoel

I'm glad one aspect is resolved. Regarding your second ask, you could try wild search (using Asterix followed by search string e.g. *12)

I hope this information helps. Please mark my earlier reply as a solution since it helped you with your original query. Please note that you can mark more than one replies as solutions if those replies help you find answers.

Kind regards
Gulshan

Was this reply helpful? Yes No