Answered

Change a Gallery's data source from a dropdown box

(0) Share

Report

Posted on by jNelly

I need some help.

I would like to change the data source of my gallery based on the dropdown box. It would be selecting a different table in SQL each time and all the tables have the same columns.

I'm really just wondering if this is possible, and if so how it could be done.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

alaabitar 1,503 Super User 2024 Season 1 on at

Like (1)

Report

Hello,

Yes definitvely possible what you can do is on the onchange of your dropdownlist you update a variable and that variable is binded to the datesource of your gallery.

Best regards,
Alaa

Was this reply helpful? Yes No
Verified answer

RusselThomas 4,014 on at

Like (1)

Report
Hi @jNelly ,
A test with SPO indicates that this works - so I guess as long as all the columns are identical across the SQL tables then no reason it shouldn't work for SQL as well...but best way to tell is to try 😊
Just edit the Gallery Items: property to something like;
If(Dropdown1.Selected.Value = "Source 1", SQLTable1, SQLTable2)
Kind regards,
RT

Was this reply helpful? Yes No