Answered

DefaultSelectedItems not working on all Combo Boxes

(0) Share

Report

Posted on by RABronn

I have two combo boxes on my form. On one, the DefaultSelectedItems works, and on the other it doesn't. Both pull from separate lists and neither list is part of the list I am saving the details to.

Property	Working one	Not working one	Comments
Layout	Single	Double	Tried changing to single, didn't work.
Items	Datasource.Title	Datasource (no column)	Tried Datasource.Column, didn't work (I also need the other columns).
DefaultSelectedItems	{Title: ThisItem.Column}	{Order: ThisItem.Column}	Also tried: {Order: DataCard1.Default} and {Order: Parent.Default}

I can't work out why one works and one doesn't.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RABronn
The DefaultSelectedItems (DSI) of your "not working" control is not correct. It is specifying a record that has a single column called Order, yet your Items property is all columns of the record of your datasource...so it will not match.

I would suggest narrowing the Items to the column that you are specifying in the DSI - DataSource.Order

Or, performing a lookup on the record from your datasource - LookUp(DataSource, Order=Parent.Default)

Otherwise, the DSI and the Items will not match and you will not have results.

I hope this is helpful for you.
RABronn 58 on at

Like
a
(1)

Report
Copy link

Link copied!

That makes sense, thank you for explaining. Your second suggestion works and is exactly what I needed.

I did try changing the Items property to DataSource.Order previously as I thought it could be that, but it did not work. I'm not sure why as it sounds like it should have done (although it wouldn't have been the best solution for me).
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@RABronn

Glad to help.

Yes, the first would work - it might not provide the results you want, but the DSI would at least match the record properly.