Skip to main content

Notifications

Community site session details

Community site session details

Session Id : guIp71F6sJ7pAwwvZ++3JT
Power Apps - Building Power Apps
Unanswered

Fill-In Choices Disappear When Navigating to Other Screens

Like (0) ShareShare
ReportReport
Posted on 9 May 2022 18:56:57 by 2

Hello! I am new to Power Apps in the last few months, and this is my first time asking a question because I could not find anyone else with this problem. If there is another thread with the answer, please let me know!

 

I have a multi-screen app that is connected to a SharePoint list. I have choice columns where I have coded the Update property of the data cards to add fill-in choices using ComboBox.SearchText. If I simply go through the app page-by-page, and hit the submit button, which uses the Patch function, it works perfectly.

 

My concern is if the user fills out the form, then decides to check their work at the end prior to submitting, the fill-in choice fields reset when they navigate back to the screen, so it is impossible to check their work. It seems that the SearchText value from the ComboBox isn’t being stored. Does anyone have a solution to this problem? Hopefully I've given enough information to help! Thank you so much in advance!!

 

I have found multiple codes for the Update Property (from this forum and from YouTube), but they all perform the exact same way it seems. This is what I currently have settled on in my app, which works as described above. This is where I found the coding sample. https://powerusers.microsoft.com/t5/Building-Power-Apps/Enter-item-manually-to-PowerApps-Dropdown-column-as-a-choice/td-p/353240 

 

  • Sharepoint: Allow ‘Fill-In’ choices set to No (I do not want to store the value for future use)
  • DataCard.Update set to following code:

         If(

              ComboBox.SearchText in Choices(‘SharePoint List Name’.'Choice Column Name’).Value,

              ComboBox.Selected,

             {Value: ComboBox.SearchText}

         )

  • ComboBox: Allow Searching set to On to allow the SearchText
  • The Patch on my Submit Button is below if that is relevant:
    • When creating a new request: Set(varRecord, Defaults('SharePoint List Name’))
    • When editing a draft from the draft gallery: Set(varRecord,ThisItem)

         Patch(
              'SharePoint List Name',
              varRecord,
              'Request Form 1'.Updates,
              'Request Form 2'.Updates,
              'Request Form 3'.Updates,
              'Request Form 4'.Updates,
              'Request Form 5'.Updates,
              'Request Form 6'.Updates,
              'Request Form 7'.Updates
         )

Thank you again! Sorry for the lengthy post! I've been struggling for almost a week.

Categories:
  • amsmiling19 Profile Picture
    2 on 13 May 2022 at 20:12:29
    Re: Fill-In Choices Disappear When Navigating to Other Screens

    Hi @v-xiaochen-msft !

     

    Thank you so much for the response and suggestion. I did try adding the 'set" function to my navigation button, and the values still disappear. 😞

     

    All of my navigation buttons use the formula Navigate(Screen), so I am not using a different formula. The OnVisible on all of my screens do have the following formula:

    UpdateContext({showPopup: false});
    UpdateContext({showPopup2: false});
    UpdateContext({showPopup3: false});

    This is because I have popups that will ask if a user is sure they want to submit, wants to delete their request, or save their work as a draft. Could that be causing the values to disappear? As long as I don't return back to the screen, the Searchtext doesn't seem to reset.

     

    If the fill-in choices won't work, is there a way I can change all of my choice values to be a single line of text without having to delete and readd the datacards? Each datacard was unlocked, and I added logic to them, so I don't want to have to redo that if possible since I have about 70 datacards that would need updating if fill-in choices aren't possible. 😕 

  • v-xiaochen-msft Profile Picture
    on 13 May 2022 at 06:26:00
    Re: Fill-In Choices Disappear When Navigating to Other Screens

    Hi @amsmiling19 ,

     

    Actually, if navigating to another screen will not reset the search value in the combo box.

    I think you maybe use some other formula when navigating to another screen.

    Back at the beginning, if you want to save the value of searchtext, I think you just need to use the 'set' function on the navigation button.

    Set(var, combobox.SearchText);Navigate(Screen)

     

    Best Regards,

    Wearsky

     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 172 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 87

#3
stampcoin Profile Picture

stampcoin 73

Overall leaderboard
Loading started