Dropdown selections not updating Sharepoint List once submitted

(0) Share

Report

Posted on by MM-07112006-0

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Are you using a Patch or Submit?

Was this reply helpful? Yes No
MM-07112006-0 49 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MM-07112006-0 49 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

What value is in the datacard update property for these comboboxes?

Was this reply helpful? Yes No
MM-07112006-0 49 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

MM-07112006-0 49 on at

Like (0)

Report

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.

Was this reply helpful? Yes No