Unanswered

I get a delegation error with this formula: If(IsBlank(TextInput2), FluenceBusinessRecoveryPrograms, Filter (FluenceBusinessRecoveryPrograms, TextInput2.Text in Champion.DisplayName))

(0) Share

Report

Posted on by MandanaDorrer

If(IsBlank(TextInput2), FluenceBusinessRecoveryPrograms, Filter (FluenceBusinessRecoveryPrograms, TextInput2.Text in Champion.DisplayName))

My datasource is Microsoft List "FluenceBusinessRecoveryProgram". My Microsoft list table is 27 rows.

"Champion" column is a persons or group column is set for multi-select.

TextInput2 is where I expect the user to enter the name

I tested it, and the equation works. But gives delegation error.

Ideally, I hoped that I could use the Concat function and Startswith but I get errors. So In practice, I can only type in one name in my column, and in my textbox, I have to type the full name correctly.

I hope someone can help me to correct at least the delegation issue.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @MandanaDorrer ,

The warning is because the in filter is not Delegable and your decision to use a Person column instead of Text is compounding this. This will work, but only on a dataset up to your Delegation limit

Filter( AddColumns( FluenceBusinessRecoveryPrograms, "MyChamp", Champion.DisplayName ), Len(TextInput2.Text) = 0 || StartwsWith( MyChamp, TextInput2.Text ) )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MandanaDorrer 21 on at

Like (0)

Report

@WarrenBelz Thank you so much, indeed! I greatly appreciate your help.

It worked. I made a minor change as I had the Champion as multi-select:

Filter (AddColumns( FluenceBusinessRecoveryPrograms, "MyChamp", Concat(Champion.DisplayName, DisplayName)), Len(TextInput2.Text)= 0 || StartsWith(MyChamp, TextInput2.Text))

Was this reply helpful? Yes No
MandanaDorrer 21 on at

Like (0)

Report

@WarrenBelz I came across a follow-up error, and that is the form after the gallery does not return any value.

In the Item for the form, I have Gallary1. Selected and that gives an error. I set a variable on the item in Gallary 1 that also does not work.

The problem goes away when I do not have the filter in the Item section of the gallery. Would you know how to solve this issue please?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @MandanaDorrer ,

The Item of your Form now needs to be

LookUp( FluenceBusinessRecoveryPrograms, ID = Gallery1.Selected.ID )

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MandanaDorrer 21 on at

Like (0)

Report

@WarrenBelz Thank you so much, indeed! It worked perfectly well.

Was this reply helpful? Yes No