Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter DataTable, getting delegation warning

(0) ShareShare
ReportReport
Posted on by 252

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.

 

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter DataTable, getting delegation warning

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

  • Verified answer
    BCLS776 Profile Picture
    BCLS776 8,988 on at
    Re: Filter DataTable, getting delegation warning

    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard