web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter DataTable, gett...
Power Apps
Answered

Filter DataTable, getting delegation warning

(0) ShareShare
ReportReport
Posted on by 256

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

 

Skybluekid_0-1686237496867.png

Having looked around, I am still none the wiser.

 

Categories:
I have the same question (0)
  • Skybluekid Profile Picture
    256 on at

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

  • Verified answer
    BCLS776 Profile Picture
    8,994 Moderator on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 401

#2
WarrenBelz Profile Picture

WarrenBelz 334 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 325 Super User 2025 Season 2

Last 30 days Overall leaderboard