How do I set a combobox with button that submits a value from a text field to the combo box

(0) Share

Report

Posted on by Future_Vision

634

Here is what I have.

Combobox with list of products including a single item called "Add Product"
A text box and button that appears if you select " Add Product"
When you add a new product to the text box and click the button the entered value is added to the combobox, via a patch to the datasource, and the combobox is refreshed.

Here is what I want:

When the button is clicked and the new value added to the datasource(combobox) I would like that new value to be selected when the combobox is refreshed.

Can this be done? I imagine it can. As an added bonus I'd probably want to hide the textbox and button when the button is clicked but I think that might be trivial assuming that the submission always works.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

GarethPrisk 2,828 on at

Like (0)

Report
Presumably the data source is Dataverse, or SharePoint.

You can:

Use a context variable to collect the value you are creating

Patch the data source to create the value

Reset the Combo Box (maybe, it can work without the Reset())

The Combo Box's Default value would be the variable, which will help it to set it as the default value. Another tricky thing with Combo Boxes is that they can have single or multiple values. This will work for single values, but will require some additional considerations to work for multiple values.

UpdateContext( { locSelectedValue: Patch( dataSourceName, Defaults(dataSourceName), {column: value} ) } )

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

I'm building the app in Teams and just selecting the "Create new table" option. Is that CDS or Dataverse?

Where would I be setting the context variable. At the OnSelect of the button? Currently, I only have a Patch function that writes the value to the datasource.

Was this reply helpful? Yes No
Verified answer

Future_Vision 634 on at

Like (0)

Report
Figured it out. I updated the button like this which seems to work
UpdateContext( { newThird : Patch( 'Third Parties', {'Third Party (cr9c7_thirdparty)':'Add 3rd Party TB'.Value} ) } )

Then set the DefaultSelectedItems to newThird

Was this reply helpful? Yes No