You’re offline. This is a read only version of the page.
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
If(
ComboBox.SearchText in Choices(‘SharePoint List Name’.'Choice Column Name’).Value,
ComboBox.Selected,
{Value: ComboBox.SearchText}
)
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.
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. 😕
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
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (