Answered

Combo Box Default Value Coming from a collection if the a variable is true.

(0) Share

Report

Posted on by OverRatedMelin

I have an app that uses other SharePoint list and cascading combo boxes to make selections. I'm looking to make another button to duplicate some of the information that was submitted on the last submission. The submit button creates a collection of the data points I need, and I have created a var "DuplicateNCR" that turns true when the duplicate button is pressed, while navigating you back to a new form, but I can't seem to get the default selection to pull in from the collection. below is the code for the default selection of the combo box. I'm not sure what I'm missing or if there is an easier way to accomplish this goal. Thanks for any help.

Default Sections.jpg

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @OverRatedMelin
According to your description, you want to set the combobox defaultselectedItems in the Form .
I test it in my side , it works good .
And this is my button-OnSelect:

SubmitForm(Form1); Set(DuplicateNCR,true); Set(LastSubmit, Form1.LastSubmit ); ResetForm(Form1); NewForm(Form1);

We need to update the DataCard-Default property:
And the Combo box property is the Parent.Default like this, and for the combo box we do not put anything in the "Default" property.

And when i select the "X" and click the button, the result is as follows:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang
OverRatedMelin 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the help!
I think there is maybe some misunderstanding. Below a sample of the submit button action pulling in single row of data into a collection. Submitting the record and setting the duplicateNCR to false.
The duplicate button in the success screen onselect sets a new form with the duplicateNCR being true.
I have set the combo box default = blank, defaultselection = parent.default, moved the if statement from the combo box to the card (code below). I don't understand your "This.Item.Choice" in your example. It looks like you might just being using a variable instead of a collection.

Card Default : If(DuplicateNCR,{Value:LastItemSubmitted.Site},ThisItem.Priority)
Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @OverRatedMelin
Thanks for your quick response and detailed description! Sorry for mu delay response due to weekend.

For your need , i test it in my side .And this is my test app:

Button-OnSelect:
ClearCollect(LastItemSubmitted,{Site:Dropdown1.Selected.Value ,Unit:"Unit Test"});
Set(DuplicateNCR,false);

Duplicate-OnSelect:
NewForm(Form1);
Set(DuplicateNCR,true);

Datacard-Default:
If(DuplicateNCR,{Value:First( LastItemSubmitted.Site).Site },ThisItem.Priority)

I think the issue you need to check is the Value , here i am using the "First( LastItemSubmitted.Site).Site".
Because the LastItemSubmitted.Site return a table type which will cause the issue. We need to make this return a Text type instead of the Table type :

Best Regards,
Yueyun Zhang