Displaying Values of ListBox in Gallery

[slhangen]

Need verbiage to display all selected values of listbox populating collection.  Using collection (colIndicators) because it is a multi-screen form.

OnSelect of Next Screen button is:

ClearCollect(colIndicators,
{
colRiskFactorsPersonality:lbRiskFactorsPersonality.SelectedItems.Value,
colGoalsPersonality:lbGoalsPersonality.SelectedItems.Value,
colInterventionsPersonality:lbInterventionsPersonality.SelectedItems.Value,
colRiskFactorsMentalHealth:lbRiskFactorsMentalHealth.SelectedItems.Value,
colGoalsMentalHealth:lbRiskFactorsMentalHealth.SelectedItems.Value,
colInterventionsMentalHealth:lbRiskFactorsMentalHealth.SelectedItems.Value
}
)

I can get first value with:

Concat(colIndicators, First(colGoalsMentalHealth).Value, ",")

How can I get all selections of each colIndicator item?

Thx so much!

[RandyHayes]

@slhangen 

I am not entirely sure if you are asking that you want to display all of the items of a particular columns (i.e. colRiskFactorsPersonality) as a comma separated list or if you want to get this in some other way.

If in a comma separated list, you could consider altering your Formula to the following:

ClearCollect(colIndicators,
    {
        colRiskFactorsPersonality: Concat(lbRiskFactorsPersonality.SelectedItems, Value & ","),
        colGoalsPersonality: Concat(lbGoalsPersonality.SelectedItems, Value & ","),
        colInterventionsPersonality: Concat(lbInterventionsPersonality.SelectedItems, Value & ","),
        colRiskFactorsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems, Value & ","),
        colGoalsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems.Value, Value & ","),
        colInterventionsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems, Value & ","),
    }
)

Note, you are assigning a single record to a collection.  You can also assign this to a lower-weight variable or even simply use the concat function in your Gallery.

But again, not sure exactly where you're trying to go with it.

I hope this is helpful for you.

[slhangen]

I just want to display any choices that are selected.  Can be up to 5 per section.

[slhangen]

Don't know the verbiage for Concat to get all the items, only the first.

[RandyHayes · Accepted solution]

@slhangen 

Yes...I gave you the formula for it:

ClearCollect(colIndicators,
    {
        colRiskFactorsPersonality: Concat(lbRiskFactorsPersonality.SelectedItems, Value & ","),
        colGoalsPersonality: Concat(lbGoalsPersonality.SelectedItems, Value & ","),
        colInterventionsPersonality: Concat(lbInterventionsPersonality.SelectedItems, Value & ","),
        colRiskFactorsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems, Value & ","),
        colGoalsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems.Value, Value & ","),
        colInterventionsMentalHealth: Concat(lbRiskFactorsMentalHealth.SelectedItems, Value & ","),
    }
)

This will give you a collection with one record with 6 columns.  Each column will be a comma separated string of the selected items in the corresponding ListBox controls.

[slhangen]

Now I see, thanks so much