@Dennis_Qiang
Put this code in the OnSelect property of your 3 buttons.
Set(varDatasource, "Table1");
Navigate(GalleryScreen);
Set(varDatasource, "Table2");
Navigate(GalleryScreen);
Set(varDatasource, "Table3");
Navigate(GalleryScreen);
Then put this code in the Items property of the Gallery.
If(
varDatasource="Table1",
SortByColumns(Filter('Your Table Name 1', 'Created By'.Email = User().Email , TextSearchBox1_6.Text in 'Part No.' || TextSearchBox1_6.Text in Customer ), "Created", If(SortDescending1, Ascending, Descending)),
varDatasource="Table2",
SortByColumns(Filter('Your Table Name 2', 'Created By'.Email = User().Email , TextSearchBox1_6.Text in 'Part No.' || TextSearchBox1_6.Text in Customer ), "Created", If(SortDescending1, Ascending, Descending)),
varDatasource="Table3",
SortByColumns(Filter('Your Table Name 3', 'Created By'.Email = User().Email , TextSearchBox1_6.Text in 'Part No.' || TextSearchBox1_6.Text in Customer ), "Created", If(SortDescending1, Ascending, Descending))
)
Please note: your tables must all have the exactly same number of columns and column names 🙂
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
