Answered

Gallery Selections to Save as One Row in Collection

(0) Share

Report

Posted on by stellarwheels

I am putting together a shopping-cart-esque request app. I want the user to select multiple items from a gallery and a drop-down action, then add it to the collection. Currently, when multiple items are selected from the gallery and submitted once, it saves each selection as its own row in the collection. Is there a way to combine the selections, perhaps separated by a comma or vertical space, rather than an individual row? I want each selection of the Add Icon to create a new row, not every gallery selection to create its own row.

Here is the app:

Here is the collection:

I would like to see one Inactivate row with all the gallery selections listed in the next column, separated by a comma or vertical space, not individual rows. If they were to submit another Inactivate request, I would want that and its gallery selections to create a new row.

My OnSelect property for the Add Icon is:

Collect(CollectionMassRequest, {
Action: DropDown_Action.Selected.Title,
Documents: Gallery_Documents.Selected.Checkbox_Document.Text
})

Please let me know if I can explain further. Thank you in advance! I very much appreciate the support available on these forums.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @stellarwheels ,

You can use "Concat()" to concatenate multiple values using a separator.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-concatenate

Basically, you will want to concatenate the text of each selected record in your gallery:

Concat( Filter(Gallery.AllItems, selected), //Datasource to serve as a base Checkbox_Document.Text, //Column from the datasource to concatenate ";" //Separator )

Add this in your "Collect()" and it should create one record with all selected values concatenated as a single text.

Was this reply helpful? Yes No
stellarwheels 60 on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey that is such an easy solution. I didn't realize I could use Concat like that. Thank you! It worked terrifically.
I'm not finding a way to get the items to separate with a Char(10) or Char(13), which would be my preference. Do you have any tips for that?

Otherwise I will happily use ";".

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Well... You can use "Char(10)" or "Char(13)" to both concatenate and split the string, though?

Concat(source, column, Char(10)) ... Split(record.column, Char(10))

Do you have some issues with those formula?

Was this reply helpful? Yes No