Answered

ComboxBox not showing value previously entered

(0) Share

Report

Posted on by Kobarg52

Although I have managed to get a few small Apps to work, I am still learning.

Currently I have a very small model-based app for administration of people working on projects. It worked quite well until I turned the "language" field into a combobox. The values for the language come from a separate table (tblSprachen). Selecting a value works fine and the details screen shows the selected value as expected. When I go back to the edit screen to make modifications, the combobox is empty.

How can I make the combobox show the value that was previsously selected?
I also tried different settings for "DefaultSelectedItems" with no usable result.

I am familiar with working with other databases like Access, so:

I think, this should not really be too difficult.

Or ist it?

Thanks in advance for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Kobarg52 - What is your data source? Because you noted there is an Edit screen and a Details screen, I assume you created this app automatically from SharePoint? Is the Language field a lookup field to the tblSprachen table, or did you modify the DataCard in the form to return the Language field directly from the tblSprachen table?

Could you take a screenshot of the code you're using on the DefaultSelectedItems property.

Was this reply helpful? Yes No
Kobarg52 5 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I should have given more information.
I created a personnell table in dataverse with ID-Number, Name, Region, Hourly Rate and Language (German: Sprache).
I then created a new model-based app which gave me the standard 3 screens.
This worked well.
Then I had the idea to change the language field in the edit screen to a combo-box. I deleted the language field in the edit screen and placed the combobox in the language data card.
I was then prompted for a source and created the language table (tblSprachen) where I entered 5 languages. The table only contains 1 field: Name.
Picking the language from the combobox obviously works well as can be seen in the details screen.
But whenever the edit screen is called again, the combobox is empty.

Was this reply helpful? Yes No
Verified answer

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!
It sounds like you need to set the default value of the combobox to the value that was previously selected. Here are some steps you can take to do this:
Make sure that you are retrieving the previously selected value from your data source. If you are not currently doing this, you will need to modify your data retrieval code to store the selected value in a variable or in your data source.
Set the "Default" property of the combobox to the variable or value that contains the previously selected value. This will ensure that the combobox is initially populated with the previously selected value.
If the "Default" property is not working for you, you can try using the "Selected" property instead. Set the "Selected" property of the combobox to the variable or value that contains the previously selected value.
If the above steps do not work, you can try setting the "Items" property of the combobox to the data source that contains the list of languages, and then using the "Default" or "Selected" property to select the previously selected value.
Here is an example of how you can set the "Default" property of a combobox in PowerApps:
Select the combobox control in your PowerApps screen.
In the "Properties" pane, locate the "Default" property.
Set the "Default" property to the variable or value that contains the previously selected value.
Save and test your app to ensure that the combobox is now pre-populated with the previously selected value.
I hope this helps you resolve your issue with the combobox not showing the previously selected value. If you continue to have issues, please provide more details or code snippets so that I can better assist you.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Kobarg52,

You did not create a model driven app but a canvas app. A model driven app is something else entirely.

To summarise then, you automatically created the default three screen canvas app from a Dataverse table. In your Edit Form, you removed the language text input control and added in a ComboBox control.

This is a typical thing to do and you only need to perform two actions:

Modify the Update property of the Datacard to point at your combo box instead of the DataCardValue. E.g., instead of DataCardValue.Text, you would need something like ComboBox1.Selected.Value. Given you are already seeing the results of your ComboBox selection in the Details screen when you save the form, I assume you have already done this.
Update the DefaultSelectedItems property of your Combobox to {Value: ThisItem.yourfieldname}. Doing this will display the current selected value for the record in your ComboBox.

Understand data cards in canvas apps: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-cards
Model Driven Apps: https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/model-driven-app-overview

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No