DefaultSelectedItems for combobox based on different list

(2) Share

Report

Posted on by PD-21101846-0

Hello Power Apps experts!

I am struggling with displaying the current values of two Combo Boxes in my form. Both are linked to different lists as data sources.

The first Combo Box uses data from the 'Product Tags' list, specifically from the text column 'Range'. The Items property of the Combo Box is set to:
'Product Tags'.Range
It submits data to the target list 'ECO TRACKER' correctly, but when I open it in Edit mode, I can't see any value—just a blank field.

I have the same issue with another Combo Box that uses data from the 'ECO TRACKER USERS' list, where the column 'USERNAME' is formatted as a Person or Group field. The Items property is set to:
'ECO TRACKER USERS'.USER_NAME
It also submits data to the 'ECO TRACKER' list correctly, but again, in Edit mode, I see a blank field.

Moreover, if the blank value is not filled in again, it deletes the current value in my target list.

I suspect the issue lies in setting the correct value for the DefaultSelectedItems property, but I haven't been able to find a solution for either Combo Box.

Thanks in advance for your advice!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi PD-21101846-0

For the first one, the DefaultSelectedItems should be (assuming 'ECO TRACKER' is a Choice column)
{Range: ThisItem.'ECO TRACKER'.Value}

For the second one, change the Items to
Choices('ECO TRACKER USERS'.USER_NAME)

then the DefaultSelectedItems should be
ThisItem.USER_NAME

and the Data Card Update
YourComboBoxName.Selected

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi PD-21101846-0,

What type of column are submitting data to in the target list 'ECO TRACKER'? Is it a Text field? Are you submitting multiple values? Are you using a form? These are all good to know details.

If you are patching a single Value to ECO TRACKER, then you use the following to display the DefaultSelectedItems:

If in a form with Item property set as selected item:

[ThisItem.ColumnName]

If you are trying to display the values in a standalone combobox:

[LookUp('ECO TRACKER', ID =SelectedItem.ID).Column]

If you are saving multiple values in ECO TRACKER using the Combobox like this: "Option1; Option2"

Then use the following to show defautlselecteditems:

Split(ThisItem.Column, "; ")

OR

//In case of a standalone Combobox Split(LookUp('ECO TRACKER', ID =SelectedItem.ID).Column, "; ")

For the second scenario, if you are patching a Person Column in 'ECO TRACKER'

//If in a form ThisItem.PeopleColumn

In case of a standalone combobox:

LookUp('ECO TRACKER', ID = selectedItem.ID).PeopleColumn

If you are patching email addresses in a text field like "Email1; Email2":

//If in a form ForAll( Split( ThisItem.PersonColumn, "; " ), First(Office365Users.SearchUser({searchTerm: ThisRecord.Value})) )

If a standalone combobox:

ForAll( Split( LookUp( 'ECO TRACKER', ID = SelectedItem.ID ).PersonColumn, "; " ), First(Office365Users.SearchUser({searchTerm: ThisRecord.Value})) )

Hope this helps solve your issues.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
PD-21101846-0 6 on at

Like (0)

Report

Thank you for answers!

Here is brief clarification:

What type of column are submitting data to in the target list 'ECO TRACKER'? Is it a Text field? - Yes for first Combo Box it is text field. For Second it is person or group data.

Are you submitting multiple values? - No, there is only one choice allowed for both Combo Boxes.

Are you using a form? - Yes, both custom Combo Boxes are in form control field.

Unfortuneatly i couldnt solve this issue. My form still works but without displaying current value.

Was this reply helpful? Yes No