Default ComboBox Selection between different screen

(0) Share

Report

Posted on by kullurumanoj

Hi All,

I would like to set Default Selection of ComboBox 2 in screen 2 based on selection item of ComboBox1 in screen 1 .

Screen1 : ComboBox 1 ...Items Selected = Apple

AutoSet - Screen 2 : ComboBox2 .... Items Selected = Selected value in ComboBox1 (How this can be acheived ? )

In between both ComboBoxes has same data sources.

Thanks in Advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kullurumanoj ,

Could you please share a bit more about your data source? Is it a SP list?

Could you please share more details about the formula you typed wihin the Items property of the ComboBox1 and ComboBox2?

Further, do you want to set the Default value of the ComboBox2 based on the selected value within the ComboBox1?

I have made a test on my side, please take a try with the following workaround:

Set the DefaultSelectedItems property of the ComboBox2 to following:

{ Value: ComboBox1.Selected.Value }

In addition, if you have enabled multiple options functionality within your ComboBox1 and ComboBox2 (set the SelectMultiple proeprty to true), please modify above formula as below:

ForAll( ComboBox1.SelectedItems, { Value: Value } )

More details about setting a Default value for a ComboBox control, please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/

Best regards,
kullurumanoj 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft
Thanks a lot. This worked for me.
My backend is Microsoft sql server.
Default Selected Items of ComboBox2 works based on the selection of ComboBox1 but I don't see values in the Combobox2. Please refer to attachment
Capture 45 : ComboBox1
Capture 46 : Combobox 2
User needs to know which items are selected in ComboBox2 as we see in ComboBox1
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kullurumanoj ,

Could you please share a bit more about the issue?

Do you want the Default selected item of ComboBox to be recognized as selected within the ComboBox available options?

On your side, please take a try with the following workaround:

Set the DefaultSelectedItems property of the ComboBox2 to following formula:

LookUp(
"The formula you typed within the Items property of the ComboBox2", /* <-- Type the Items property formula of your ComboBox2 here */
FilteredColumn = ComboBox1.Selected.Value
)

Note: The FilteredColumn represents the column you want to display within your ComboBox2.

Best regards,
kullurumanoj 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft ... Thanks very much
This is what exactly I am looking for
My items Property for ComboBox2 : SortByColumns(col2,"Program_Name")
My defaultSelectedItems : {Program_ID: ComboBox6.Selected.Program_ID }

col2 has two columns : Program_ID, Program_Name
Is this how I need to write formula LookUp(col2,{Program_ID: ComboBox6.Selected.Program_ID }) ?

I am getting error when I write this Invalid type record expecting boolean value instead

Best Regards,
Manoj
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kullurumanoj ,

There is something wrong with your formula, you should modify your formula as below:

LookUp( SortByColumns(col2,"Program_Name"),
Program_ID = ComboBox6.Selected.Program_ID )

Please take a try with above formula, then check if the issue is solved.

Best regards,
kullurumanoj 74 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot @v-xida-msft .. Worked perfectly I was using { } , so got that error