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 / Custome made sharepoin...
Power Apps
Answered

Custome made sharepointlist wont save combobox input

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I made a sharepoint list, which i customized with Powerapps to be able to search for Office365Users within the list.

All of this is already working but my problem is, when i select a person it wont save.  What am I doing wrong?

 

I read somewhere, that i need a Patch, but I´ve never worked with this and I don't know how it works...

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    You don't need a patch for this.  

    The primary questions are, what is your Items property of your combobox, and the Update property of the Datacard that contains it.

     

    If you combobox is using the standard method, it should have something like : Choices([@yourDataSource].yourPersonColumn)

    And, the Update property on the Datacard should be:  yourCombobox.SelectedItems  or yourCombobox.Selected depending on if your person column is single or multiple people selections.

     

    I hope this is helpful for you.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for answering!

    In Items I have: Office365Users.SearchUser({searchTerm:ComboBox2.SearchText, top:10})

    In Update I have: ComboBox2.Selected
    If  I want to write ComboBox2.SelectedItems I get a error

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    This is because you are basing your combobox on an Office 365 user record and trying to then save that as a SharePoint user record...these are two completely different records.

     

    Is there any particular reason to use the 365 users and search like that rather than have it set as Choices([@yourDataSource].yourPersonColumn)  ??

     

    If there is a particular reason, then you will need to modify your Update property to the following:

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

     

    Also, if you stick with the 365 search, then you should consider changing your Items property of the combobox to:

    Office365Users.SearchUserV2({searchTerm: Self.SearchText, top:10}).value

    As SearchUser is now deprecated and shouldn't be used in new apps.

     

    I hope this is helpful for you.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I use the 365 users because we use the list as a planner. Each new entry is a new task and we want to search within 365User who is going to be responsible for this task.

    So we only need new name of the person... Is there another way to write Update?

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    I provided what you need for the Update.  Are you having some issue with that?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Yes, sadly this is not working... I still have the same problem. I just cant save the information i selected in the combobox

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Okay...let's recap then.

    Can you provide me the following (I think I have a lot of them, but I want to make sure):

    1) The Default property of your DataCard

    2) The Update property of your DataCard

    3) The DefaultSelectedItems property of your Combobox

    4) The Items property of your Combobox

    also

    5) That we are dealing with a Single select Person column in your list

    6) That when you say it is not saved, that you have confirmed this by looking at the actual record in the list and not just that it is not displaying when you view the item again (this is significant).

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Default: I have nothing

    Update: {Claims:"i:0#.f|membership|" & Lower(ComboBox2.Selected.Mail),
    DisplayName: ComboBox2.Selected.DisplayName,
    Email: ComboBox2.Selected.Mail}

    DefaultSelectedItems: Nothing

    Items: Office365Users.SearchUserV2({searchTerm: Self.SearchText, top:10}).value

    5) Yes, we are dealing with a Single select Person column in my list

    6) I confirm it everywhere all the time, it is not saving


  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

     

    1) The Default property of your DataCard

        Default: I have nothing

        The Default property of your DataCard should be ThisItem.yourColumnName

     

    2) The Update property of your DataCard

        Update:

    {Claims:"i:0#.f|membership|" & Lower(ComboBox2.Selected.Mail),
    DisplayName: ComboBox2.Selected.DisplayName,
    Email: ComboBox2.Selected.Mail
    }

        As mentioned in Message #4, this needs to be:

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

       Please change accordingly.

     

    3) The DefaultSelectedItems property of your Combobox

        DefaultSelectedItems: Nothing

        This should be:

    Office365Users.SearchUserV2({searchTerm: ThisItem.yourColumnName.Email}).value

     

     

    4) The Items property of your Combobox

        Items: Office365Users.SearchUserV2({searchTerm: Self.SearchText, top:10}).value

        This is fine.

     

    also

    5) That we are dealing with a Single select Person column in your list

     Yes, we are dealing with a Single select Person column in my list

      Very good!

     

    6) That when you say it is not saved, that you have confirmed this by looking at the actual record in the list and not just that it is not displaying when you view the item again (this is significant).

     I confirm it everywhere all the time, it is not saving

      Yep, not with the formula you had for update.  Just wanted to make sure that nothing was going in the actual record.

     

    Correct the items above and see how that goes.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I get the following error messages:

    AndreaSterac_0-1614944082869.png

    AndreaSterac_1-1614944118348.png

     My column is named "Zuständig Intern" but apparently something is wrong. Can it be because of the "ä"?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard