Unanswered

Delegation Issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am building an app using sharepoint lists and connecting them through IDs. I am trying to filter a gallery with the ID of an item selected in the previous gallery and with a search box. The screen looks like this.

The code I have right now works fine since I still have not surpassed 2000 items in my list but it will soon be close to that number. This is the current code I'm using

Filter(
Entry_Details_1,
Employee_ID_100 = Gallery3.Selected.EMP_ID,
StartsWith(LookUp('SOP Header',SOP_ID = SOP_ID_2,'SOP Label'),TextInput6.Text)
)

The first select filter has no issues but the second condition is giving me a delegation problem. I'm not sure if it has to do with the fact that the title of the gallery is also a lookup. The code for the text of the title is this.

LookUp('SOP Header',SOP_ID = ThisItem.SOP_ID_2,'SOP Label')

I thought it was strange that I was getting a delegation error since according to this table both the StartsWith and Filter functions can process complex types without delegation.

I also thought it might have been because I was using multiple tests in one function but the same delegation error popped up when I was only testing that one filter condition.

Could anyone help me figure out what's going on, where the problem is coming from or how to solve it? I would appreciate any help.

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Does this work? Your LookUp seems a bit odd to me, are you using a label or is 'SOP Label' a single line of text column used to filter a table?

With{wheader:LookUp('SOP Header',SOP_ID = SOP_ID_2,'SOP Label'), _items:Filter(Entry_Details_1,Employee_ID_100 = Gallery3.Selected.EMP_ID) }, Filter( _items, StartsWith(wheader,TextInput6.Text ) )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, Thanks for the help. What do you mean when you say the lookUp looks off? Yes, 'SOP Label' is the name of one of the columns in my table that I'm using to filter the gallery. Your code seems promising but for some reason powerapps is not recognizing the columns in the Entry_Details_1 that I need for the lookup function. I thought this might be because of the order that the functions were listed but I'm not sure. Thanks for your help anyways, I'll try some more on my own to see if I find anything but would appreciate any other tips.