Announcements
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
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 solutionIf you like my response, please give it a Thumbs Up.
Hi @Amik
No I am using Datatables, not Gallery
@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 - 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' )
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:
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
That is correct, but it seems not to be working, am I doing anything wrong?
@developerAJ
Do worry I have sorted it!
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224
