web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dropdown column config...
Power Apps
Unanswered

Dropdown column configured as lookup on a canvas form will not save back to Sharepoint List

(0) ShareShare
ReportReport
Posted on by 11

 I have a canvas app with the datasource a sharepoint list. The list has several columns configured as "Choice" and on the form I've set the Items control for each to a list of choices. This works fine and the entry is saved back to the Sharepoint List when I submit the form. But I have one column that I cannot save back to the list. In SP I have tried various types, choice, person and text. On the form, I want this to be a dropdown people picker, and the Items control contains this: SortByColumns(Office365Groups.ListGroupMembers("GroupID",{'$top':999}).value,"displayName",Ascending).

there are about 700 users in the list and this part works perfectly, but when I make a selection and submit the form, no data is saved back to the list. The other fields are populated but this one is empty. I believe I need to modify the Update Control on the datacard associated with this column. I've found various solutions online but they all throw errors. .The original text that's in the Update control is Datacard#.selected. This doesn't throw any error but also doesn't save the data back to SP. If I display the selected name from this dropdown in a label somewhere on the form, it works so I know the name is actually being selected properly. Would appreciate any suggestions. 

Categories:
I have the same question (0)
  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 1 on at

    Hi @mpreziosi ,

     

    You need to set the Update property of the datacard correctly.

     

    In this topic you can find how to do that: https://powerusers.microsoft.com/t5/Building-Power-Apps/Updating-an-SP-List-from-an-Office365Users-data-source/m-p/634293/highlight/true#M201162

  • mpreziosi Profile Picture
    11 on at

    Thanks but I've seen that post and tried something like that. I keep getting errors such as "Name isn't valid. DisplayName not recognized" although the displayName is valid. 

  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 1 on at

    Hi @mpreziosi ,

     

    Can you please share what you tried together with the error message(s)?

  • mpreziosi Profile Picture
    11 on at

    Thank you very much for helping. The formula I tried in the update control is below. Below that I've pasted a screenshot of the table that is generated by the Items formula on the dropdown and below that is a screenshot of the error. It's just "Name isn't valid. "DisplayName" isn't recognized.

    {
    Claims: "i:0#.f|membership|" & Lower(DataCardValue3.Selected.DisplayName),
    DisplayName: DataCardValue3.Selected.DisplayName,
    Email: "",
    Department: "",
    JobTitle: "",
    Picture: ""
    }

    mpreziosi_0-1675696717155.png

     

    mpreziosi_1-1675696832564.png

     

     

  • BCBuizer Profile Picture
    22,833 Super User 2026 Season 1 on at

    Hi @mpreziosi ,

     

    When trying for myself I was able to get this right, but I don't see an obvious difference with what you have:

     

    BCBuizer_1-1675723235662.png

     

    You may want to try Sort() instead of SortByColumns():

    BCBuizer_2-1675723384321.png

     

  • mpreziosi Profile Picture
    11 on at

    Thanks, that didn't work either. Even if I remove the "sort" completely, i get the same error. But I notice in your screenshot you are displaying the data in a gallery. Do I need a gallery? I'm completely new to Powerapps, it seems like a great tool but maybe I'm not understanding something. My form is based on a sharepoint list and I want the data to go back to a sharepoint list. I did some reading but it didn't seem like I needed a gallery to collect data for a SP list. 

  • mpreziosi Profile Picture
    11 on at

    Just following up to let folks know how I ultimately solved this. In my SP list I created a new column with the type "single line of text". In PowerApps I added this to the form but hid it. I added a PowerApps combobox with this formula in the Items control:

    SortByColumns(Office365Groups.ListGroupMembers("6a0e7b09-6039-4fb5-a639-412060fd9ed6",{'$top':999}).value,"displayName",Ascending)

     

    Back to the hidden textbox, for the Default control, i put something like this: ComboBox2.Selected.displayName

    Where "ComboBox2" is the name of the ComboBox above. In this way the value from the ComboBox is added to the textbox, and that in turn saves back to the Sharepoint list when the form is submitted. This is kind of clunky and I wish I didn't have to do it, but it's the only way I could get it to work. I've got several fields set up this way and so far, so good. Thanks again to BC for your suggestions.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 316 Most Valuable Professional

#2
11manish Profile Picture

11manish 242

#3
Valantis Profile Picture

Valantis 198

Last 30 days Overall leaderboard