Click button and change Datasource table on gallery screen.

(0) Share

Report

Posted on by Dennis_Qiang

If i have three button and three sharepoint list. And i have one gallery screen.

If i click one button to navigate to gallery screen. My gallery screen code is below:

SortByColumns(Filter( 'PF502X Sample Request', 'Created By'.Email = User().Email , TextSearchBox1_6.Text in 'Part No.' || TextSearchBox1_6.Text in Customer ), "Created", If(SortDescending1, Ascending, Descending))

How to setup button onselect code and gallery screen code can achieve that change button to navigate gallery screen and the gallery screen datasource table will change by the button represent.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report
@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."

Was this reply helpful? Yes No
Dennis_Qiang 96 on at

Like (0)

Report
Hi @mdevaney

Can i use the below type?
For three button,

Set(varDatasource, "Table1"); Navigate(GalleryScreen); Set(varDatasource, "Table2"); Navigate(GalleryScreen); Set(varDatasource, "Table3"); Navigate(GalleryScreen);

For the Gallery,

SortByColumns(Filter('varDatasource', 'Created By'.Email = User().Email , TextSearchBox1_6.Text in 'Part No.' || TextSearchBox1_6.Text in Customer ), "Created", If(SortDescending1, Ascending, Descending))

Is it possible to store the table in a variable?

Was this reply helpful? Yes No