Quick Find to show all records on Account entity

(0) Share

Report

Posted on by Zii

Hi - I am looking to see if a quick find view can show Account names for example - If I type Ottawa it should search all accounts starting with ottawa or something like city of ottawa and not only show exact names.

Now in contact - there is field called first name and last name so its easy to set criteria to search with those names. However in Account we only have Account Name field, so the search looks for exact match.

The old classic CRM has this feature and was easy to use, not sure why this is not available in powerapps.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Zii,

What is your data source type and size ? For instance if you are using Dataverse, you can use the Search function supported by Delegation, so
Search( YourTable, YourSearchBox.Text, 'Account Name' )

would find any entries in the 'Account Name' field containing the string the user entered in the search box. If you are using SharePoint, there are some restrictions on the number of records you could query with this, but this can often be addressed with a delegable pre-filter.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Zii

Try using * infront of the word and search the same.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
Zii 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

WE are using dataverse and I am looking a way to add something into the quick find view itself and publish this changes. However your suggestion looks like a code and I will try to add that.

@Ram Prakash Duraisamy : I am aware of this however our users are looking a way to not use this.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Zii

I can totally understand, but i feel there is no other way to find the same, else we need to write code against RETRIEVE MULTIPLE to achieve the same. Lets wait for others responses too.

Please mark as answer if my suggestion helps.
Subscribe here for More Useful videos : https://www.youtube.com/@rampprakash3991

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Zii,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Zii 10 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz: No it did not work I beleive the suggestion you gave is for canvas app and mine is Model-driven / CRM Quick Find: and I want to configure the table’s Quick Find View where I do not want to use "*" and allow users to search with Account names like ottawa and give any account that has account in it.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Zii,

Yes - it was for Canvas Apps - it is a good idea to state your app type as it will generally affect the response content. I assumed Canvas as that is what the large majority of the community posts deal with. I do not use MDAs, so unfortunately cannot be of a lot of assistance here.

Was this reply helpful? Yes No