Answered

Filter DataTable, getting delegation warning

(0) Share

Report

Posted on by Skybluekid

256

Filter('Tbl', 'Part No'=ComboBox1.Selected.Value,If(Toggle3.Value,STATUS="Delivered",true),If(Toggle4.Value,'PO Num'=POTable.Selected.'PO Num',true))

I have the above on Datatable. What it is doing is not returning all the results that I am expecting. If I was to just have

Filter('Tbl', 'Part No'=ComboBox1.Selected.Value), it would returning 10 lines, which what I expect. However, when I apply the formula as above, it misses out the bottom 5 values. I also notice that I get the below warning, with a blue line

Having looked around, I am still none the wiser.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Skybluekid 256 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much. After watching YouTube videos on delegation, I understand what you have done.

Was this reply helpful? Yes No
Verified answer

BCLS776 8,994 Moderator on at

Like (1)

Report
Copy link

Link copied!
To make it delegable, try this:

With({aFilter: Filter('Tbl', 'Part No' = ComboBox1.Selected.Value)}, Filter(aFilter, If(Toggle3.Value && STATUS = "Delivered", true), If(Toggle4.Value && 'PO Num' = POTable.Selected.'PO Num', true) ) ) //Note, the Filter logic is modified a bit to what I think you meant for conditions

Hope that helps,

Bryan

Was this reply helpful? Yes No