Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Filter a datatable from a selection of another

(0) ShareShare
ReportReport
Posted on by 252

Hi All,

 

I have a datatables, which contain a PO number.  When I select a row, I would lie to pass that value to filter another Datatable, which contains PO number

 

Any help would be appreciated

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter a datatable from a selection of another

    @developerAJ 

    Do worry I have sorted it!

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter a datatable from a selection of another

    That is correct, but it seems not to be working, am I doing anything wrong?

  • developerAJ Profile Picture
    developerAJ 2,837 on at
    Re: Filter a datatable from a selection of another

    @Skybluekid 

     

    Output of the second query is 

    when you turn on toggle it will filter items using status column and give you items with status as Delivered.

     

    if toggle is off it will give all items. i hope that's what you are looking for

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter a datatable from a selection of another

    Thank you @developerAJ .  Just one other, I have a toggle which filters out orders that filters out only delivered items on the second datatable.  I am using the following: 

    Skybluekid_0-1685689652901.png

     

  • Ami K Profile Picture
    Ami K 15,655 on at
    Re: Filter a datatable from a selection of another

    @Skybluekid - you can try the below in the items property of the Data Table to be filtered (e.g. filter Data Table 2 based on a selection in Data Table 1)

     

     

     

    Filter(
     'Your Data Table 2',
     IsBlank('Your Data Table 1'.Selected) || 'Your PO Column' = DataTable1.Selected.'Your PO Column'
    )

     

     

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

    If you like my response, please give it a Thumbs Up.

  • Verified answer
    developerAJ Profile Picture
    developerAJ 2,837 on at
    Re: Filter a datatable from a selection of another

    @Skybluekid 

     

    Please refer below formula

     

     

    second datatable item Property: Filter( datasource,IsBlank(DataTable1.Selected.PO) ||PO=DataTable1.Selected.PO)

     

     

    Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Filter a datatable from a selection of another

    Hi @Amik

    No I am using Datatables, not Gallery

  • Ami K Profile Picture
    Ami K 15,655 on at
    Re: Filter a datatable from a selection of another

    Hi @Skybluekid - just so I understand, you want to filter a Gallery based on the selection of another Gallery?

     

    ------------------------------------------------------------------------------------------------------------------------------

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution

    If you like my response, please give it a Thumbs Up.

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard