Hi everyone. I am having an issue where the Combobox/Dropdown lists in my PowerApps form appear to be working properly, but they are not posting to my Sharepoint List when I submit the form in PowerApps. There are 4 ComboBox fields in my form, the only 2 that are not working is the “Supplier Name” (VendorList) and “Code Code” (CostCodeList) lists, which are pulling pre-defined values from Excel tables on Sharepoint (APVEN.VENDNAME & GLAFS.ACCTID). This is confusing to me because I’m obviously selecting the values and they are populating the form fields, but no values are passing through to my Sharepoint List. All Combobox fields are ‘Choice’ type fields in the Sharepoint List. I’ve included a few screenshots below to try to capture some of the properties fields – maybe someone can see something that I can’t? There are currently no errors showing up in PowerApps.
Dropdown selections not updating Sharepoint List once submitted
Ok this is now solved after days of frustration.
The "Choice" fields in the Sharepoint List must have been causing issues and after days of troubleshooting I ended up starting from scratch with those 2 columns.
1. I created 2 new "Text" columns and added the new fields to my PowerApps form.
2. Since PowerApps now recognized these as Text input fields, I had to create a new Combobox Input in each Datacard, and deleted the Text Inputs.
3. I had to update the Items/Default/Update properties to properly reference the new Combobox Inputs since the Datacard was referencing the Text Inputs.
This seems like such a basic function that I'm surprised this workaround is required. But there we go! Thank you everyone for your feedback.
Dropdown selections not updating Sharepoint List once submitted
Hi, you can see that property in the first screenshot, its VendorList.Selected (VendorList is the name of the first combobox). I've seen suggestions that it should have .Value or .FIELDNAME or .Result or .Text at the end of it, but PowerApps wont allow me to add any of those because its referencing a Field in Excel to populate values.
Dropdown selections not updating Sharepoint List once submitted
Well that didn't work. I did the TrimEnds() function to the Transform Query function directly in the Excel file. Refreshed the data in PowerApps and nothing has changed.
Dropdown selections not updating Sharepoint List once submitted
I’m using submit.
I think I know what is causing the issue. My Excel Field that is populating the Dropdown list has a bunch of trailing ‘spaces’ after the text, while PowerApps automatically trims the trailing spaces when it inserts those values into the Dropdown box. So it’s basically comparing auto-trimmed values in my form to untrimmed values in Excel. Does anyone know which DataCard/Property I should be editing to include TrimEnds()? Hopefully that’s a quick fix, but I’ve tried using this command on multiple properties and datacards/datavalues and it just results in errors so far.
Dropdown selections not updating Sharepoint List once submitted
Are you using a Patch or Submit?
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.