Answered

Multiple ListBox selections into Collection

(0) Share

Report

Posted on by jworth_tcs

I am trying to get a ListBox working whereby a user can select multiple options and then click on a button and it adds these selections into a collection.

I can get it to a point whereby if a user is selecting for example, two things from the ListBox, and click the button, it will then two records into the Collection. However, it always adds these two records with the first selected item in the listbox. I.e. if 1 and 2 are selected, it creates two records both with 1 rather than one with 1 and the other with 2.

Is there a way of getting it to work as required?

I've tried various different ways, but cannot get it to work.

Many thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@jworth_tcs

In most cases you don't need a collection as the Listbox control already has a table of the selected items.

But if you want to duplicate it into a collection, then use the following:

ClearCollect(yourCollection, yourListBox.SelectedItems)

You can also capture this into a variable:

Set(yourItems, yourListBox.SelectedItems)

-or-

UpdateContext({yourItems: yourListBox.SelectedItems})

Or you can just refer to yourListBox.SelectedItems in any place that you need to reference the currently selected items.

I hope this is helpful for you.

Was this reply helpful? Yes No
jworth_tcs 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes - many thanks for your prompt response. I have given this a go and it still adds to the collection the number of records based on the number of selected values. However, the entries all have the first selected item in the listbox rather than adding one record per listbox selected item.

Screenshots are below of the various aspects.

I've only just got my head round collections and Galleries. Am I misunderstanding something, hence it not working?

Thanks again

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jworth_tcs

I assume that you are using Timesheet_Entries as your Items property on the Gallery.

Your formula there is referencing the selected value of the ListBox1 - this will always be the same value.

Change your formula to the following:

ClearCollect(Timesheet_Entries, ForAll( ListBox1.SelectedItems, { ClaimDate: Date_WeekDay_Day & " " & Welcome_drpClaimMnth.Selected.Value & " " & Welcome_drpClaimYear.Selected.Value, ClaimReason: Timesheet_txtClaimReason.Text, ClaimStartTime: Timesheet_lblStartHrMins.Text, ClaimFinishTime: Timesheet_lblFinishHrMins.Text, ClaimHrMinDec: Timesheet_txtClaimHrMinDec.Text, ClaimMonth: Welcome_drpClaimMnth.Selected.Value, ClaimYear: Welcome_drpClaimYear.Selected.Value } ) )

Note on the above - ForAll returns a table, simply assign it to what you want, in this case a collection. It is commonly misused as just a loop...it returns a value.

Also note that you are creating a record for each ListBox1.SelectedItems record. So, you set your ForAll to that record source and then reference the value in that record. In this case the Date_WeekDay_Day.

Also note: unless for some reason you need a collection, you can just assign this formula (minus the clear collect line and associated closing paren) to the Items property of your Gallery.

That should give you what you need.

Was this reply helpful? Yes No
jworth_tcs 8 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes - that's worked perfectly! Thanks very much for your help.

Was this reply helpful? Yes No