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.
Thank you very much. After watching YouTube videos on delegation, I understand what you have done.
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