web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter DataTable, gett...

Power Apps

Answered

Filter DataTable, getting delegation warning

(0) Share

Report

Report

Posted on by Skybluekid

262

Hi

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 Img

All responses (2)

Answers Img

Answers (1)

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
Skybluekid 262 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

Join the conversation