web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps DefaultSelected - Comb...

Power Apps

Answered

DefaultSelected - ComboBox not working

(0) Share

Report

Report

Posted on by Community Power Pla...

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 Img

All responses (4)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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... on at

Like (0)

Report

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... on at

Like (1)

Report

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,297 Super User 2024 Season 1 on at

Like (1)

Report
@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

Join the conversation