Check if string contains any of the substrings in the list

(1) Share

Report

Posted on by rajujoseph

I have a Dataverse table with more than 5000 records. The canvas app I am building have a search screen which allows users to search for movie titles that contains specified string. Users can use multiple search strings separated by ";".

For example, if I have a movie tile called "Casablanca" and if users type "as; ap", it should return the record since "Casablanca" contains the string "as". However, if they specify "ap; bu", this record will not be returned.

I have the following filter condition which is working with warning:

Filter(
    MovieTitles,
    IsBlank(TitleTextInput.Value) || Sum(ForAll(Split(TitleTextInput.Value, ";"), If(Trim(Value) in rxj_primarytitle, 1, 0)), Value) > 0,
)

However, the above condition results in a delegation warning.

Is there any way to search without delegation warning? Any suggestions?

Categories:

General Questions

All responses (1)

Answers (0)

abc 123 784 Super User 2025 Season 1 on at

Like (1)

Report

Check if string contains any of the substrings in the list

I'd probably Split() the search values and put them into something that could then be used by ForAll().

Then use the ForAll() to Collect the titles that match each of the split patterns.

Finally, do a Distinct() to extract the unique values.

Probably want to sort it prior to showing the user. Weave one of those in somewhere.

I haven't fully researched the use of Ungroup() yet, but this is the second time I've seen it used. Give this a good read and see if it scratches the itch:

Alternative to the 'in' operator for Power Apps when filtering SharePoint data - michelcarlo