cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Englishweb
Level 8

Dropdown lists - how to preserve last saved value?

Hello

Does anyone have a simple solution for preserving the last saved value in a dropdown list  (in a gallery) please?

I have checked that the reset = false but it still reverts to the first item on the list after saving the selection.

 

Many thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Englishweb
Level 8

Re: Dropdown lists - how to preserve last saved value?

Hello Rezza

The lists are being populated from an excel table.

1 The Prof Contact list (Items= ProfContactTable) This currently resets to its first value (blank).

2 The Matieres list depends on the subjects boxes :Filter([Maths.Text,Aeronautique.Text, Systemes.Text,Vehicules.Text,Anglais_SH.Text],Not(IsBlank(Value)))

(This resets to first value on list)

 

I'm saving the values to Excel using Patch:

Patch(SUMMARYDATATABLE,ThisItem,{S1Subject:SubjectList1.SelectedText.Value,S1ProfContact:ProfContactList1.SelectedText.Value, );UpdateContext({LetsEdit: false})

Can I retain the last selected values in the dropdown lists?

View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: Dropdown lists - how to preserve last saved value?

Hi @Englishweb 

 

How is the gallery being populated? from which datasource?

 

Screenshots would help

Englishweb
Level 8

Re: Dropdown lists - how to preserve last saved value?

Hello Rezza

The lists are being populated from an excel table.

1 The Prof Contact list (Items= ProfContactTable) This currently resets to its first value (blank).

2 The Matieres list depends on the subjects boxes :Filter([Maths.Text,Aeronautique.Text, Systemes.Text,Vehicules.Text,Anglais_SH.Text],Not(IsBlank(Value)))

(This resets to first value on list)

 

I'm saving the values to Excel using Patch:

Patch(SUMMARYDATATABLE,ThisItem,{S1Subject:SubjectList1.SelectedText.Value,S1ProfContact:ProfContactList1.SelectedText.Value, );UpdateContext({LetsEdit: false})

Can I retain the last selected values in the dropdown lists?

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,476)