Answered

Default selection for combo box connected to collection made from sharepoint?

(0) Share

Report

Posted on by wiranqa

I'm having trouble selecting the default item for a single select, searchable combo box. It is connected to a collection "MARGINS" made by the collect of a sharepoint list. I'm hoping to set the default selection to the second item on the list, "40%". I cant figure out the code or if it should be in default or default selected items.

This is the items code for the combo box:

Sort(ForAll(Distinct(MARGINS,Margin), {Result: ThisRecord.Value}),Result,SortOrder.Descending)

Thank you!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @wiranqa ,

Your Items can be (the Result syntax was only to address a legacy output change some time back)

Sort( Distinct( MARGINS, Margin ), Value, SortOrder.Descending )

If you simply want "40%" as the default, the DefaultSelectedItems would be

{Value: "40%}

If you want the second item (whatever it is) as the default

{ Value: Index( Sort( Distinct( MARGINS, Margin ), Value, SortOrder.Descending ), 2 ).Value }

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
wiranqa 47 on at

Like
a
(0)

Report
Copy link

Link copied!

I am making updates to a ~3 year old app! The second suggestion worked, now to remove a tonnnnn of "Selected.Result" elsewhere in the app...
Thank you for your help!
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @wiranqa ,

If you do not know this already, you can search for the word Result with the bottom icon in the left menu. I did mine as soon as the syntax change was rolled out.