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
Englishweb Post Patron
Post Patron

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 Post Patron
Post Patron

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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,818)