web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Change combo box Item ...
Power Apps
Answered

Change combo box Item source using a Variable

(0) ShareShare
ReportReport
Posted on by 14

I'm trying to use a single form to handle multiple customer lists based on what Region is selected.

I'm wondering if I can dynamically change the item source based on a previous dropdown

 

Like concatenating two strings to create a reference to a source name

 

BGuinn_0-1600393889624.png

 

Categories:
I have the same question (0)
  • Verified answer
    PaulD1 Profile Picture
    2,914 on at

    You can change a filter predicate dynamically - so if all your data were in one table and you had a column for the Region, you could do:

    Items:  Filter(tblSales, SalesRegion = varSalesRegion)

     

    You cannot specify the table with Sales_ & var_Reg. PowerApps evaluates everything 'on the fly' for the App Checker and intellisense won't be able to figure out what datasource you want and so what fields should be listed unless you explicitly specify the table you want to use.

    You might want to try, in the onchange of your first combo something like:

    If(First(cboReg.Selected.Items).Reg = "SouthReg", set(varReg, SalesRoute_SouthReg))

    Where SalesRoute_SouthReg is actually the table.

    And then just use varReg for the Items property. I have one similar for the Items property of a Datatable but that was just for a quick 'utility' that only I was ever going to use - I wouldn't trust that in a Production system.

    I would be especially wary of using this technique with combos as, in my experience, they are quite finicky about the data source and if you change it, you might find you lose your parameters for the Display and Search fields.

     

    Safer would be to have multiple combos, one for each region, and base their visible property on the chosen regions.

    Better still would be to normalise your sales data so that it is in a single table with a field for 'Region' (instead of being split across multiple tables, one for each region) and then use a filter to get the appropriate subset of data.

  • BGuinn Profile Picture
    14 on at

    @PaulD1 Yep, that sounds about right. I had seen some older posts using the switch function to manipulate the source. I was trying to get around some of the sharepoint constraints. My customer list is 240,000 customers and that exceeds the sharepoint limits of >50mb limit of sharepoint upload and >20,000 rows. 

     

    Since I'm new, I was looking for ways around those sharepoint list limits by splitting the source. Thanks for the info.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard