Change a Gallery's data source from a dropdown box

Like (0) Share

Report

Posted on 21 Jul 2022 14:44:19 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:

Connecting to Data

All responses (2)

Answers (2)

Verified answer

RusselThomas 4,012 on 21 Jul 2022 at 14:59:23

Like (1)

Report
Re: Change a Gallery's data source from a dropdown box

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
Verified answer

alaabitar 1,503 Super User 2024 Season 1 on 21 Jul 2022 at 14:59:12

Like (1)

Report

Re: Change a Gallery's data source from a dropdown box

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