web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering the gallery ...

Power Apps

Answered

Filtering the gallery is causing a delegatioin issue

(0) Share

Report

Report

Posted on by xrxr031

95

Hello Experts !!

I have a gallery where i am getting information from a sharepoint list. I want to filter the gallery by a textinput box where the user can search by the submitter email or by status. The status column is a choice column where the options are New, In Progress and completed. I use the formula below but it gives me a delegation problem. Is there a way i can write this formula where there is no delegation issue?

Filter('MySharepointList', StartsWith(Title, TextInput1.Text) Or StartsWith(Status.Value,TextInput1.Text)

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Anchov 1,986 on at

Like
a
(1)

Report
Copy link

Link copied!
One way to get rid of the delegation warning is to change your Status formula to an 'equals' operator instead of using StartsWith function.

Filter('MySharepointList', StartsWith(Title, TextInput1.Text) Or Status.Value = TextInput1.Text)

The downside is the user will have to type in the whole Status value before the filter kicks in (may not be a big deal). Alternatively you can filter the status with a drop down box and the Title with the Search input.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

@xrxr031 ,

Just adding to @Anchov 's comments, one of the reasons I do not use Choice columns is exactly this - consider converting it to Text and doing the Choices in Power Apps. You will also find that you cannot Sort by a Choice column with Delegation.

Was this reply helpful? Yes No

Join the conversation