Unanswered

Combobox not saving last inputs - excel sheet

(0) Share

Report

Posted on by Community Power Pla...

Hi.
I am a fairly new Power Apps user, looking for a way to make comboboxes recall the last selected input for an app I am making.
It requires that the user can return to the form and edit their choices without losing the input in their comboboxes once data is submitted to the form.

Currently I have gotten to the point where I can display the relevant text from the related datacard in the combobox using the DefaultSelectedItems property using the code "{Value: DataCardValue2.Text}".

However, if I submit that form, return to the edit screen, then submit the form again without changes, the resulting output on the relevant datacard is blank. This means the user has to input into ALL the comboboxes again every time they make a mistake and want to edit something. That is not intended and time consuming.

I am using an excel sheet as my datasource.

The Comboboxes are single-choice.

I know I am not providing a lot of information, so please ask for the relevant information as I am new and not entirely sure what is necessary, to explain the problem I am having.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RJM07 801 on at

Like (0)

Report

One option you could use is, when you first save the data in the combo box, also save the selection into a variable. Then you could use that variable to populate the default properties of the other box?

Not sure how well it'd work for you, but it's an option

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hey! Thanks for your response.
I am not sure what you mean by that.
I am already saving the combobox selection in the DataCard, which is where it is displayed to the user when not editing.
Then, as you can see, I try fetch that with the code {Value: DataCardValue2.Text}, however, it only seems to display the text, not actually populate the spot where you'd otherwise select a valid option.

If that's not what you meant, could you elaborate?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

A guess I have is that using DataCardValue.Text is not a valid option for the combobox as the combobox is using a different datatype to handle selections than string, which is why I end up with a blank value.

I guess the solution would entail getting the correct datatype to the Combobox1 DefaultSelectedItems property.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

I have solved the issue.
I set the DefaultSelectedItems property to be the same as the Item property.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

As a note to this, this only fixes the problem partially, but if I simply take my data from a new table in Excel, where I store the data, the solution should work.

Was this reply helpful? Yes No