How to display multi select combo box values in a HTMLText box

[AndrewGibson1]

Hi all,

I have a combo box in a form in my Power App where users can select multiple values. Once the form in the Power App has been updated the next step is for some staff to then hit a button which compiles all form information into a PDF file. This is achieved by displaying all form fields in between html in a HTMLText box, and then passing this information to Power Automate which converts the html into a PDF file.

eg

"<tr>
<td><strong>Title</strong></td>
<td>"

&

galReports.Selected.'Item Title'

&

"</td>
</tr>
<tr>"

All is well except when trying to bring in the multiple values of the combo box. I have tested that I can retrieve this information in the App by using a listbox elsewhere on the screen to display all of the values

galReports.Selected.'Field Name'

However I cannot work out the code to display this within the HTMLText box. Thanking those in advance who can offer assistance.

regards,

Andrew

[WarrenBelz]

Hi @AndrewGibson1 ,

Use 

Concat(galReports.SelectedItems,'Item Title' & ",")

this will put a comma between them but you can use an delimiter you want.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[AndrewGibson1]

Thanks Warren,

I have added that in, but it doesnt seem to like the syntax we are using. Note I need to replace the "," with ',' at the end as the " in a HTMLText box is used to interchange between HTML and PowerApp formulas

The error message I get when I hover over this is:

"Name isn't valid. This identifier isn't recognised.

The function 'Concat' has some invalid arguments"

[WarrenBelz]

@AndrewGibson1 ,

I just noticed the control name used - is this a Gallery or the combo box?

The syntax is correct for a Combo Box (so use that control name) and you need “”, not ‘’.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[AndrewGibson1]

galReports is the name of the gallery. 'Biomedical Cause' is the name of the combo box (ie the control name).

I have switched '' back to "" and no joy

[WarrenBelz]

@AndrewGibson1 ,

Want are the Items of the Combo Box ‘Biomedical Cause’ ? You need

Concat('Biomedical Cause'.SelectedItems,xxxx & ",")

where xxxx depends on the Items property of ‘Biomedical Cause’

When you type ‘Biomedical Cause’.Selected. (note second dot), valid values will come up underneath. For some guidance of what they mean: -

• If your Items are Choices(ListName.FieldName) - a Choices or Lookup field), xxxx will be Value
• If they are Distinct( . . .  .), it will be Result
  The other option is when they are based on a field value in a list (other than Distinct), then it will be FieldName (actual field name)

To test this before putting into the HTML, put a label on the screen with just the Concat code.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[AndrewGibson1]

Back in my PowerApp I create a label and add the following in as text and yes, it wants to show Value given the datasource is a Choice field in a SharePoint list.

When I add the concat formula in the text property of the new label 

Concat('Biomedical Cause'.SelectedItems,Value & ",")

I get the following error message

"Invalid use of '.'

The function 'Concat' has some invalid arguments"

I would of thought we would need to bring in galReports.selected as a prefix to the formula somewhere given we are trying to show the values of the selected item in a Gallery?

So I tried changing the formula in the label to

galReports.Selected.Concat('Biomedical Cause'.SelectedItems,Value & ",")

but I got a message:

"Invocation of unknown or unsupported function" so obviously I was getting way off track...

[WarrenBelz]

@AndrewGibson1 ,

Before we get of track here, the Concat() syntax for a multi-select combo box is correct. Is your combo multi-select?
It probably is irrelevant as you now mention you want the items “selected” in your gallery - I assume you mean the values in the combo boxes?

I will be offline for a while and need a PC to test so try the process in a few hours after you confirm this. Can you please explain the process you are trying to capture.

[AndrewGibson1]

Warren, thanks for your patience with me on this - as I'm relatively new to this so perhaps not explaining myself that well.

The gallery is not showing the values of the combobox, but a list of SharePoint items.

For each SharePoint list item there are about 24 columns (fields) of data. Of these fields, 1 is a Choice field that can hold multiple values.

These 24 fields are shown in the PowerApp as a form for users to populate values against each record.

I then have a separate page where certain admin users can prepare a PDF report for each record (that shows the values of each field for the selected record).

To enable this we use a gallery that lists all of the SharePoint items (records), and when users select a one of these its populates a htmltext box with the field values for that selected record (and most fields populate using the formula of galReports.selected."fieldname"). The one field I am having the issue with is the "Biomedical Cause" multi select combo box as it seems to need different syntax .

[WarrenBelz · Accepted solution]

@AndrewGibson1 ,

This should work

Concat(GalReports.Selected.'Biomedical Cause',Value & ",")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.