Looking at others who've asked a similar question, my scenario seems to be a bit different.
I have a combobox that I want to display vehicle accessories depending on what vehicle type is selected.
Here is the table with the accessory values per vehicle:
And the form:
So if the user selects small hatch, ideally they wouldn't be able to select Towbar as an option in the combobox. Though this isn't critical. The main functionality I need is to pull the specific cost of each selected optional extra from that list, to be used in a Sum further down. So if they selected first aid kit and rubber mats, the cost will add on 250.
The Sum is just adding up the costs of everything the user has selected (based on vehicle and lease length). Currently I just have a list with 1 amount for each accessory being used for all vehicles, which isn't very accurate for budgeting (which is the purpose of the form). The estimate will either be too high or too low.
Hello @rsparks ,
If I understand you correctly, you want the user to be able to choose specific extras based on the type of car they select.
To do this:
See attached SampleApp and study the concepts lined out.
Hope this helps you learn PowerApps!
Using that table layout you've provided, I've made a list in Sharepoint that has 3 columns. Vehicle Type, Option and Cost.
Rather than managing the table within powerapps, I'd rather do it in Sharepoint so that I can share access (and as such pass maintanence of the table to someone else). How would I go about using filters to recreate the same functionalities that your app has?
I need the choice combobox to filter the Option column based on the Vehicle Type selected in a dropdown further up in the app. I'm not quite sure how to do that for a choice function, but I imagine it would something along the lines of embedding the Filter within the Choice.
Then for summing the costs of each Option I would have to repurpose this function:
Round(((Sum(Filter('Optional Extra Costs',OptionalExtraName in ComboBox2.SelectedItems.Value),OptionalExtraCost))/Dropdown10.Selected.Val), 0)
Any suggestions for getting the Choice combobox working based on a Sharepoint list rather than a table set up as a collection?
Nevermind, copied over your collection, gallery and checkbox ideas. Works very well.
2 more questions, first is how do I patch the "Goodies" data to my Extras column in a list?
The old function I had was {'Optional Extras Package': Left(Concat(colMyItems, Value & ", "), Len(Concat(colMyItems, Value & ", "))-2)}.
Should I simply replace colMyItems with colCarsOptions?
Second, how do I make the gallery/datacard resize themselves based on how many choices are visible? As below, it doesn't look great with all the empty space if you're looking at a small hatch.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
207 | |
187 | |
82 | |
54 | |
37 |
User | Count |
---|---|
288 | |
245 | |
119 | |
78 | |
55 |