Automatically adding rows with all dropdown values

(1) Share

Report

Posted on by KalvisT

131

Hei,

I have an app where I'm using cascading dropdowns. One of the dropdowns has multiple values.

Lets say dd1 and dd2 has default value selected by logged on user but there are 4 values to choose from in dd3. Is it possible that when I add the values to a collection that a row is created for all the 4 values in dd3 with previously selected values in dd1 and dd2? So that the user doesn't have to add a row for each value in dd3 manually but 4 rows are created with a single click of a button, value from dd1,dd2 and each of dd3?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (2)

Report

Is this a combobox or Dropdown and yeh you could use a forall and a patch or a collect of the selecteditems it depends on the nature of the collection and input.

If you are unfamiliar on how to do this:

do you have the current formula for how it adds one row at a time currently?

and can you confirm if its combobox or dropdown. Sharing the items property and collection name may be helpful. in the forums aswell as the current formula.

Was this reply helpful? Yes No
KalvisT 131 on at

Like (0)

Report

This adds the items to collection drp = dropdown and cob=combobox. The one who has multiple values is the drpTjeneste_1

Collect(SLACollection,{Col_Tjeneste:drpTjeneste_1.Selected.Tjeneste,
Col_Avdeling:drpAvdeling_1.Selected.Result,
Col_Seksjon:cobSeksjon_1.Selected.Result,
Col_Date:DatePicker2.SelectedDate,
Col_SLA:drpSLA.Selected.Value,
Col_Kundekonsekvens:drpKundekonsekvens.Selected.Value})

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @KalvisT ,

Do you want to create a row for each of the multiple values selected by Combo Box?
I agree with what @AJ_Z said, you could use the ForAll() function to achieve your needs.
I have made a test for reference.

1,Add 2 DropDown Control and a ComboBox Control.
2.Add a Button Control and apply the following formula on its OnSelect property as:
ForAll(ComboBox1.SelectedItems,Collect(coltest,{column1:dropdown1.Selected.Value,column2:dropdown2.Selected.Value,column3:Value}))

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
KalvisT 131 on at

Like (0)

Report

Thanks a bunch to you both. Didn't have experience with ForAll before. Now i'll just have to adjust it for my needs and maybe make it so that app selects all available values in the combobox based on the user and other cascading dropdowns.

Was this reply helpful? Yes No
SA-20081442-0 18 on at

Like (0)

Report

Hi
I have same issue and tried your fantastic solution, but my result is not the same. I have in all lines same drop down value (the last choosed). I mean if I select 2 item I have 2 rows with same combobox value and not one with each one. what am I doing wrong?

Thank you

Capture.JPG

Was this reply helpful? Yes No