Answered

Default Selected Item for ComboBox

(0) Share

Report

Posted on by cmegow

Hi. I have a ComboBox with the items formula 'SortByColumns(Distinct('FPC-Purchase Orders'.School,School),"Result")'. I've read several posts about how to ensure the selected value is the default in edit mode using DefaultSelectedItems. So, I set the DefaultSelectedItems to Filter(Distinct('FPC-Purchase Orders'.School,School),Result) but it's not keeping the selected item selected when editing the form. Can someone please correct my formula, please!

Thank you for any help you can offer.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@cmegow,
Based on the issue that you mentioned, do you want the ComboBox to keep the selected item when in edit mode?
Could you please share a bit more about the scenario?
Let me make it easy for you, the DefaultSelectedItems of the ComboBox expects a Table rather than a record or a value.
I have a test on my side, please take a try as below:
Set the DefaultSelectedItems property of the ComboBox as below:

[ThisItem.School]

Best Regards,
Qi
cmegow on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft Thanks for the suggestion. I tried changed the DefaultSelectedItem to ThisItem.School and this is the error that I got:

I do wish to have the item that is selected upon creation of the item to be the default item in the combo box when the item is edited. So far, I have not been able to get the selected item to show up when edited. Other thoughts?

Thanks again for your help!
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi@cmegow,
Could you please try the formula I provided again?
The following is my formula that the brackets "[" "]" are necessary. The ComboBox DefaultSelectedItems property needs a Table and the brackets format it to be a Table.
So please try the "[ThisItme.School]".
Best Regards,
Qi
cmegow on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft Thank you. the addition of the brackets fixed the context conflict. Much appreciated.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I search forever and you solved it. Thank you.