ComboBox Default Selected Items

(0) Share

Report

Posted on by kanda

Hello,

I'm encounter an issue with how to set default selected items in ComboBox.

My app is embedded in PBI, load record from PBI and allows user to update records which stored in a SharePoint List. I have a ComboBox which linked with a Single line of text field. I set the 'DefaultSelectedItems' property as Filter('Tier Board Action Plans - all text columns', ID = Gallery1.Selected.ID).Branch I can actually see the data I want but it doesn't show in the ComboBox.

Any help would be greatly appreciated.

Thank you in advance!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

kanda 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I solved this problem, change the 'DefaultSelectedItems' property to:
ForAll(Filter('Tier Board Action Plans - all text columns', ID = Gallery1.Selected.ID), {Result: ThisRecord.Branch})

btw, the Item property is:
Sort(ForAll(Distinct(Filter('Tier Level Mapping', 'Super Branch' = Dropdown7.Selected.Result),'BU Name'), {Result: ThisRecord.Value}),Result)

However, even though I solved this issue, I don't understand why I have to use ForAll and {Result: ThisRecord.Branch}. Could anyone help me to understand what happened inside?

Thank you!
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kanda ,

You did not include the Items of the ComboBox, but I suspect they are from a list field - whatever ComboBoxName.Selected

{ Branch: Filter( 'Tier Board Action Plans - all text columns', ID = Gallery1.Selected.ID ).Branch }

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
kanda 8 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you @WarrenBelz
Since I use 'Result' in the Item property, so changed your code to
{ Result: Filter( 'Tier Board Action Plans - all text columns', ID = Gallery1.Selected.ID ).Branch }
It works perfect!
Thanks again!