Dropdown lists - how to preserve last saved value?

[Englishweb]

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!

[RezaDorrani]

Hi @Englishweb 

How is the gallery being populated? from which datasource?

Screenshots would help

[Englishweb · Accepted solution]

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?