Answered

DefaultSelected - ComboBox not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a SharePoint list column "products". Its being updated by my powerapp using form > combox with the below formula:

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

It writes on the sharepoint okay with format product1, product2, product3

However, when I use the DefaultSelectedItems, its not showing the current data it has for products. I tried the below formula but its not working:

ForAll(Split(Parent.Default,", ",LookUp(colVisible,'Products'.Value))

colVisibile is the collection I use with all data.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

What is the Items property of your combobox? The records in the DefaultSelectedItems (DSI) property MUST match the schema of the Items property in order to match.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

The combobox has the Item = ["product1","product2","product3"]. Its just a static options I put in and data type appears to be table.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks! gave me the idea and used the below formula instead:

RenameColumns(Split(Parent.Default, ","), "Result", "Value")

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

One additional habit to get into when splitting text for default selected items is to utilize the filter function to remove anything that is not valid. The reason is, if there is a blank record in the DSI items, then the combobox will "look" like it has the items selected, but if you look closer at the actual dropdown list, you will see that they are not really selected...this is because the blank causes issues.

So your formula would be:

RenameColumns( Filter( Split(Parent.Default, ","), !IsBlank(Result) ), "Result", "Value" )

Glad you got it working!

Was this reply helpful? Yes No