Answered

Canvas App - Fuzzy Search / Matching

(1) Share

Report

Posted on by FAQA

Hey,

I’m not sure how many hours of forum searches, ChatGPT and trial an error I have behind me, but I can’t seem to find a solution.

I have a Canvas App where the user can input a text string.

In a gallery I then want to use some fuzzy logic to only return items from a SharePoint list that match the user input.

Has anyone done something like this, with or without leveraging Power Automate?

For performance purposes I’d prefer an in-app-solution of course, but at this point, I take what I can get 😄

Best

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi FAQA

The only Delegable search syntax with SharePoint Text fields is equals (exact match) or StartsWith. You can use a "wildcard" string that needs to contained sequentially in the target string on smaller lists (Search function or in Filter) however nothing beyond that. The same applies really in Power Automate.

Please click 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 giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Weird cause its answered all over.

That being said, you didn't specify how they were doing their input, as in what into what control?

As Warren said, its limited :-(

Was this reply helpful? Yes No
FAQA 30 on at

Like (0)

Report
Copy link

Link copied!

Hey Warren and Mike,

I found a few things about it, that’s right, but since most of it is 2 or more years old I thought maybe something changed there.

@Mike:

The user inputs the desired company name in a modern text input.

This value should then be fuzzy matched with a column in a SharePoint list where the item will be created if it doesn’t exist yet.

Best

Maxi

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The fundamental issue is that no "fuzzy logic" filters exist for Power Apps or Power Automate. Also Modern controls are really not production-ready presently, although this has no bearing on your query.

Was this reply helpful? Yes No
Verified answer

FAQA 30 on at

Like (1)

Report
Copy link

Link copied!

Alright, thanks - then I'll think of something else.

Was this reply helpful? Yes No