Answered

Choose Data Source based on Gallery selection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm currently trying to populate a Gallery (Gallery2)

with a Data Source that is determined by the selection of another gallery (Gallery1). Gallery 1's source has a column with the Data Source Tables that I'd like to populate Gallery 2. However, I've learned you can't use a variable or "gallery1.selected" in the "Items" field of Gallery 2. I've seen some solutions, but I'm having trouble making sense of them for my situation. Any help would be great!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

You might be interested in this recent thread about dynamic data sources.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-I-create-a-dropdown-that-picks-different-data-sources/m-p/717376#M229566

In summary, you would base the items property of Gallery2 on a Switch statement that refers to Gallery1.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@timl

Thanks for the response.

I've updated Gallery 2's Item formula with what i got from that other discussion. However, Gallery 2 doesn't respond when I click the item in Gallery 1 that would work with this formula
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@timl

Got it to work by setting the first part of the switch variable that was set when I chose from Gallery 1. Thanks for the help!

Is there a more streamlined way to do this if my information was hosted somewhere else? I'm running into issues with the 2000 item issue with PowerApps, which is why I need different Data Sources (Multiple Excels instead of 1)
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

I'm glad that works. I think my comment to you in this post addresses the question above. If not, feel free to post a new question.

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-can-I-create-a-dropdown-that-picks-different-data-sources/m-p/718498/highlight/false#M229972