Limitations of Forall function

(1) Share

Report

Posted on by CP-23071818-0

107

After being educated by Warrenbelz in the previous post of mine and Reading a Matthew Devaney article on Delegation and Forall I understand the limitation in a forall is 2000 however it might ease my mind in dealing with a Delegation warning i have with the Statement below. I get a Delegation warning around Checkbox2_1.text my question being is what is technically the "target" of the delegation? is it Gallery1? or ECI_Dies_1 SP list? the only reason this is a question to me is that technically Checkbox2_1 is a control inside Gallery1, and Gallery1 Datasource is a DIFFERENT SP list. so when the Delegation warning is orange underlining Checkbox2_1.text does this mean the forall cant see more than 2000 in Gallery1, ECI_Dies_1 or the other SP list? because if its Gallery1 then i can be at ease becuase it will NEVER reach that much. but the other 2 SP lists have a chance over time.

ForAll(
   Filter(
      Gallery1.AllItems, 
      Checkbox2_1.Value
   ) As _Data, //Filter Gallery1 items for checked boxes and call these records _Data
   With(
      {
         _Record:
         LookUp(
            ECI_Dies_1,
            dienum = _Data.Checkbox2_1.Text &&
            eci_id = SelectedRecordTitle1_1.Text
         ).dienum
      }, //establish named record using look up to check for matching Dienum and eci_ID

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Please share the code with the warnings on them so we can see, you have it there, share it don't try to explain it. Cannot tell whats the targer exactly as you didn't share a picture. Be assured a picture s always better than you trying to explain something you can see, but for some reason aren't sharing with us.

Also, your filter is nothing more than a true or false, what exactly were you trying to filter out?

Was this reply helpful? Yes No
Suggested answer

rzainm 107 on at

Like (0)

Report
Copy link

Link copied!

Whatever your Datasource in Gallery1 is. It's better if you can avoid delegation warnings, but if data of Gallery 1 wont reach 2000, that's probably fine. Also, is there no delegation warning on your LookUp? LookUp is non-delegable from what I've experienced.

Was this reply helpful? Yes No
CP-23071818-0 107 on at

Like (0)

Report
Copy link

Link copied!

FLMike please see the pictures you requested, i apologize for this being so late but I couldnt get replies out, this reply may even not make it through, i have a ticket out.

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

Like (0)

Report
Copy link

Link copied!

Hi CP-23071818-0

I will add something here as I have been involved with this app before (as you mentioned). I think asked this last time as to how and why you are wanting to refer to the Text property of a text box, which I assume in your case must be dynamic (a formula). If it refers to another data source (other than ECI_Diss_1), then Power Apps needs to resolve a relational lookup, which is not Delegable. I know technically it should read the label, but clearly it does not want to do this.

Was this reply helpful? Yes No