Populate a text field with a combo box multi-select value and then pass it back if selected

(0) Share

Report

Posted on by lalford09

163

Hi,

I am trying to create a form that has a field that is a text field in DV - but in the form I am using a combo box instead to populate it with items from a collection. The combo box is multi select, I then want to populate the text box with the items selected in the combobox when the form is in New Mode.

The form can then also be populated when a user selects that item from the Data table, in which case I would then want that combo box to show the items based on the item selected.

Currently I am using this formula in the default of the datacard:

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

However this only populates the field in DV with the first selected item?

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lalford09,
You can set the DefaultSelectedItems property of ComboBox as:
If(IsBlank(DataTable2.Selected),Test07171S,DataTable2.Selected)

And set the Default property of DataCardValue as:
Concat(ComboBox2.SelectedItems,Name,",")

Note that Name is my field in DataVerse.

Best Regards,
Kyrie

Was this reply helpful? Yes No
lalford09 163 on at

Like
a
(0)

Report
Copy link

Link copied!

Tahnsk @v-mingkz-msft however this isn't quite working

I have set both the properties you have mentioned above however the text field in DV is only populating with the last selected option from the combo box, and then when I select an item from the data table, the combo box is staying blank instead of pulling through the value(s), any ideas?

Can I also just check that Test0717S is the name of your DV table?

Thanks

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@lalford09,
Sure, the Test07171S is Dataverse table.
Could you please show some screenshots about your Combobox and textbox?

Was this reply helpful? Yes No
lalford09 163 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure @v-mingkz-msft

Here is the DefaultSelectedItems of the combo box

Here is the default of the text box:

The Reason it is ThisItem.Scope_Covered as that seems to be the only available option linking to my DV table

And then here you can see that when I select the item from the data table, the text box populates with the one selected item (even though I chose 4 originally), but not the combo box

Was this reply helpful? Yes No
lalford09 163 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mingkz-msft Thanks for your help, I have managed to find a working solution here:

Saving and displaying multi-choice Combo Box in a Text field – Practical Power Apps

Was this reply helpful? Yes No