Announcements
I'm trying to follow some steps in a blog to create an app where the users can update items in bulk. First they filter a gallery based on a dropdown for customer name/vendor. Then there is another dropdown with a list of collectors that they can choose from. I would like them to be able to select one person from the list of collectors and update the Collectors column in all of the filtered results to match the collector they have chosen. This is where I get a little lost. Do I need to create a collection based on this data, or is the data source sufficient? When I create an "Import Data" control and try to select the Excel workbook I receive the error "There was a problem importing your data. Make sure the file you are using is a PowerApps file." Any and all help would be greatly appreciated.
Thanks,
Carl
Where is the data coming from?Dropdown1 Has the collectors
Dropdown2 Has what? (I will call it objects, just for now)
Does the orginal data look like this..
Collector_Name Collector_Object
Bob Dole CoinsIf so, you can easily do this using the "Depends on" property of DropDown2
They both get their values from two different columns in the same data source. The requirement isn't to set up a cascading/dependent dropdown but rather to select from the list of available collectors and then use that value to update all of the items we filtered in the gallery using dropdown 1.
This blog is exactly what I am trying to recreate but only using one dropdown field to filter the results of the gallery(for now)
https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Bulk-updates-for-a-filtered-gallery/ba-p/99558
I've created the filter on the gallery based on the values returned in dropdown1 but now I'm lost as to how to update those filtered items using the submit button. Thanks for your help.
To answer your question:
Dropdown 1 Dropdown 2
Customer Name Collector
I want to filter the results in the gallery based on what is selected in drop down one and then use the selected collector in dropdwon 2 to assign the same collector to all of the filtered results in the gallery. Does that make sense?
Sure.
You want to filter the gallery like this.
On the ITEMS property of the gallery put this formula.
Filter(Repairs, Accessories = Dropdown3_1.Selected.Value)
In this case, Repairs is the Data source, Dropdown3_1 is the dropdown you want to use as the filter.
Then for the label (or what ever is storing the Collector) in the gallery card, but this formula.
Dropdown2.Selected.Value
Dropdown2 being your collector.
https://snipboard.io/Z1sQGO.jpg
Thank you for responding. I've gotten that far but what I'm asking about is the next step to update the list in bulk.
This is my screen. I have the filter based on the Customer/Vendor Name in place for the gallery. From there I want to be able to select a name from the dropdown for Collector, check the checkbox and then click submit and have it update the Collector column with that collectors name for those items in the gallery.
This is the formula I currently have in place.
If(Checkbox1.Value=true,UpdateIf('Collections DB', "Customer Name"=Dropdown1.Selected.Result, {Collector: Dropdown4.Selected.Result}))
It doesn't return any errors but also nothing gets updated when I press the button.
Gotcha!
Okay, so what is the data source?
Is it a SharePoint list, excel file? Etc..
It's a SharePoint list. Thank you!
You need to patch the data to sharepoint.
ForAll(Gallery1.AllItems, Patch('Collections DB', {ID: ID},{Collector: Dropdown5.Selected.Text}))
It worked! But for some reason it only updated 4 of the 5 items in the screen. Any idea why that might be? Thank you so much for your help.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional
