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.
