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
That is correct, but it seems not to be working, am I doing anything wrong?
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
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 - 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.
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.
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.