Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Dropdown selections not updating Sharepoint List once submitted

Posted on 19 Nov 2024 17:59:09 by 49
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.


  • Suggested answer
    MM-07112006-0 Profile Picture
    MM-07112006-0 49 on 21 Nov 2024 at 14:44:59
    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. 
  • MM-07112006-0 Profile Picture
    MM-07112006-0 49 on 20 Nov 2024 at 13:19:23
    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.
  • ronaldwalcott Profile Picture
    ronaldwalcott 660 on 20 Nov 2024 at 03:33:09
    Dropdown selections not updating Sharepoint List once submitted
    What value is in the datacard update property for these comboboxes?
  • MM-07112006-0 Profile Picture
    MM-07112006-0 49 on 19 Nov 2024 at 21:10:53
    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.
  • MM-07112006-0 Profile Picture
    MM-07112006-0 49 on 19 Nov 2024 at 20:52:12
    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.
  • ronaldwalcott Profile Picture
    ronaldwalcott 660 on 19 Nov 2024 at 20:39:09
    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.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,051

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,793

Leaderboard