Unanswered

How to keep selected value when updating drop down

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an application that I have developed that uses several drop down lists in order to prevent manual data entry.

However, if someone were to want to update a previous entry, it reverts back to the first item.

Which value do I need to update in order for the drop down to keep its original entry?

I'll provide an example:

Here is a user I would like to change information on.

When I go into edit mode, AccountStatus is reverted back to "Active" and NGGroup is reverted back to "Administration"

I would like to make it to whereas its original information is kept.

If I could get pointed in the right direction, I would greatly appreciate it.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Is the drop-down single-select

What type of field is it writing back to (and the name of this field)

What are the Items of the drop-down

What is the Update of the data card

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

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz

Single-select

They are text data fields that are writing to nchar(10) data types in a SQL database. In the example, these text fields are called "AccountStatus" and "NGGroup"
For "AccountStatus" the items are: ["Active","Inactive"]

For "NGGroup" the items are: ["Administrators", "BH", "BH FOC", "BH Intake", "BH Instake Exception", "Billing II", "Billing Manager", "Billing Staff", "Call Center", "Case Management", "Credentialing", "DataFile", "Dental", "Dental Assistant", "Dental Director", "Dental Front Desk", "Dental Providers", "Fiscal", "Front Office I", "Front Office II", "Health Center Managers", "Health Education", "Health Home Staff", "ID Print", "Medical Assistant I", "Medical Assistant II", "Medical Records", "MR/Call Center Supervisor", "Navigators", "Navigators/Scheduling", "NextGen Administrators", "Nursing Staff", "Optical Staff", "OSIS", "Pharmacists with Default Rights", "Pharmacy Staff", "Preceptor", "Providers", "Read-Only Auditor", "Referral Staff", "Referral Supervisor", "Reporting Staff", "Rosetta Acess", "Template Administrator", "Trainer" ]

The updates of the data cards are "AccountStatusDropDown.Selected.Value" and "NGGroupDropDown.Selected.Value"

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The update properties are correct for the Items, which only leaves the data type. You did not mention it was SQL (and I use SharePoint) but my understanding is that nchar(10) is limited to 10 characters and I can see more than that in your options.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Yes, that is correct. I will plan on updating the character size later on.

This does not answer my question though.

What I'm asking is if I'm editing a previous entry, how do I keep the dropdown to select what's already there?

For example, the selected user's AccountStatus is set to "Inactive" and the NGGroup is set to "Dental"

But when I want to edit this entry, the dropdowns go back to the first items on the list, which are "Active" for AccountStatus and "Administration" for NGGroup.

I am asking for is if there is already data entered for this field, how to keep it selected for that matching data on the dropdown vs going back to the first item on the list?

I'll provide screenshots again for more clarification.

Detail Screen:

Edit Screen

I only screenshot the fields in question but this is already a user that exists in the database.

I would like for it to where on the edit screen, it stays at the selected value so that way nobody has to do any extra data entry work.

Thank you for your assistance.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

If a drop-down, what is the Default, if a ComboBox, what is the DefaultSelectedItems?

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

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz,

Right now, the default is set to Parent.Default.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

Assuming this is a drop-down (not a combo box), that should work - try ThisItem.AccountStatus and ThisItem.NGGroup

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

I'm sorry, I haven't had much time to work on this application today.

I will try again whenever I get a chance and I will respond to this thread if I'm still having any issues.

Thank you for following up!

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

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

It's still reverting back to the first item on the list when I try to update.

Was this reply helpful? Yes No