web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Keeping the value in c...
Power Apps
Unanswered

Keeping the value in combobox after refreshing the form

(0) ShareShare
ReportReport
Posted on by 44

Hello,

 

i would like to keep last saved value in combobox, after i reopen the same form.

Store values in SPlist.

 

Somewhere in forum i found that on properthy on Select of button i wrote:

SubmitForm(Form1);Navigate(BrowseGallery1);

ClearCollect(LastChoice,{Value:Last(SPlist).parts1})

 

COmbobox is in datatacard of Form1 

in properties DefaultSelectedItems of combobox i wrote variable: LastChoice. 

 

The issue what i have is that when i reopen the form, the value is visible in combobox - so it saved, saved value, but when i change something in form1,  and left the combobox alone, the value in comobox, do not retains in combobox and detelets from SPlist.

 

How it is possible that, whatever i do in form, the value still stays in combobox and in SPlist, to be able to keep datas and in future change value if nessesarry. 

 

Categories:
  • v-mingkz-msft Profile Picture
    Microsoft Employee on at

    Hi @11playto16,

    Do you want to display the submitted value in combo box?

    I can't understand your description about the value in comobox, do not retains in combobox and detelets from SPlist.

    I assume that you want to display the last submitted value and if the variable changed still display the value in SharePoint list.

    If so, please set the on select property of button as:

    SubmitForm('Form4');Set(LastStatus,Form4.LastSubmit.Status)

     Set defaultselecteditems property as:

    If(IsBlank(LastStatus),ThisItem.Status,LastStatus)

    vmingkzmsft_0-1689661182876.png

     

    Best Regards,

    Kyrie

     

  • 11playto16 Profile Picture
    44 on at

    Hi Kyrie,

     

    the point is, to keep, selected item in combobox in combobox, no matter you change something in form or just submit the form. 

    Because right now, 

    i put value to combobox, and save the form, when i reopen it again to change something in form, and do not touch the combobox, because i see that the value is still selected,(because of defaultselecteditems) i submit the form. And here comes the issue, the value was selected but while it is last submit - i think, the value not preserved and disappear just like when i have not selected anything in combobox. 

     

    If(IsBlank(LastStatus),ThisItem.Status,LastStatus)

    For this code, it writting - expected table value

    this is my items:

    Sort('spareparts'.parts,parts)

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard