cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Englishweb
Post Patron
Post Patron

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

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
RezaDorrani
Dual Super User II
Dual Super User II

Hi @Englishweb 

 

How is the gallery being populated? from which datasource?

 

Screenshots would help

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?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,715)