Issue with Combo box while displaying the default selected items

(0) Share

Report

Posted on by Sja855

I am really facing a strange issue in PowerApps combobox, I am pulling the data from Snowflake and there is a text column where all the names are available.

In PowerApps I am displaying these names in a combobox by setting the default selected property as given below and it is able to display those names in Combobox.

 ForAll(
      Split(
         column name,
         ";"
      ) As aDisplayName,
      First(Office365Users.SearchUser({searchTerm: aDisplayName.Value})).DisplayName
   )
 
But when I tried to display these names in text label it shows nothing, I am using the formula on text property of the label is 
"Concat(ComboBox3.SelectedItems, DisplayName, ";")"
 
 
Can anyone please help?
 
Thanks in Advance!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Suggested answer

Mark Nanneman 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

What do you have in the "Items" property of your Combobox?

How you write the Concat() on your ComboBox's selected items depends on the structure of the collection in the "Items" property.

What are the Items for your combobox?

If it's a simple array of single strings (no objects+properties) like this:

Then you'd write

Concat(ComboBox1.SelectedItems, Value &";")

If your items are a datasource with columns, then you'd reference the column name instead of "Value"
Sja855 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mark Nanneman,

Thanks for your response.

The item property is the office 365 connector search formula, as shown in the below.

The aim of this ComboBox is to update the users names in the column by searching it in office 365 profile.

I am just checking weather it is giving the proper result or not along with the existing names and newly searched names but not. Can you please suggest me the proper way to do this

Thanks in Advance!
Mark Nanneman 993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I don't think you need the ".value"

This works for me:
Sja855 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mark Nanneman,

Thanks for your response. I am already able to search the names and pick it in the ComboBox using the formula. I need to update all the names into the table(Data source) column.

Suppose, I already have 2 names from the datasource table column which are being displayed in the Combobox and I search for the new name and pick it up in the combo box, when use the formulae to Concat(Combobox.selectedItems, DisplayName, ";") to get the result of 3 names and update back into the table column It only shows the 3rd name but not the 2 names already available in the column and being displayed in the combobox that's what the issue is. You can find these screenshots in the main issue description above.

Any suggestions to overcome this will be appreciated.

Thanks in Advance!