Unanswered

Fuzzy search in portal (on lookup)

(0) Share

Report

Posted on by fuzzygoose

Hi all,

Have a business requirement to 'fuzzy' search a column. A simple solution that would work for us is to automatically append/prepend wildcares like so `*searchterm*`.

I haven't been able to find a good/clean solution for this. It appears that some of the solutions that are available in the model-driven apps are not available for portals?

Hope to hear your best practice!

Thanks

Categories:

Power Apps portals

I have the same question (0)

All responses (2)

Answers (0)

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

To create a fuzzy search on a lookup in Power Pages:

Use a Dataverse table. Enable wildcards in your search using the like operator. Update the page dynamically with results using JavaScript.

Steps:

1. Create a FetchXML query in Dataverse:

2. Use a custom web API to expose this query. Ensure it accepts a search term as input.

3. Add JavaScript to your Power Pages site to call this API when the user types in the lookup field:

4. Test the lookup by typing in the field and confirming it dynamically updates with partial matches.

5. Ensure proper security settings on your Dataverse table and API permissions.

Was this reply helpful? Yes No
SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

fetch xml query is below

<fetch>
<entity name="account">
<filter>
<condition attribute="name" operator="like" value="%searchterm%" />
</filter>
</entity>
</fetch>

Was this reply helpful? Yes No