cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

Re: Saving data from powerapps to SP lists person/Group column

At least it's working 🙂 

E.g. nullifying Person fields doesn't even work at all:

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        Claims:"",
    Department:"",
   DisplayName:"",
         Email:"",
      JobTitle:"",
       Picture:""
   }

 

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Saving data from powerapps to SP lists person/Group column

Thanks @v-micsh-msft for this great reference! I have gone back to this many times and it has helped a lot.

 

This helped me achieve a similar goal of creating a new SharePoint list item with an entry in a multi-select person column for each row in a collection which I posted below in case it helps someone else.

 

Essentially, this allows attendance taking without searching for each person's name in the Office365 directory but rather maintaining a  list of "members" to each committee and then offering these as choices to mark "attended" or not. I also included a combobox to search for and and occasional attendees and visitors which are then patched in at the same time.

 

The collection

 

"build collection of committee members who are checked as attended";
ClearCollect(colMembersToAdd,
       ForAll(Filter(Gallery1.AllItems,Checkbox1.Value= true),
                {
                    DisplayName:DisplayName,
                    Claims: Claims
                }
             )
            ) 

 

The patch operation

 

"patch one entry into multi-select person field with a person for each person in collection colMembersToAdd";
Patch(Attendance,Defaults(Attendance),
    { Title:"Meeting Attendees", 
    Attendees:
    ForAll(colMembersToAdd,    
                {   
                    Claims:Claims,
                    Department:"",
                    DisplayName:"",
                    Email:"",
                    JobTitle:"",
                    Picture:""
                }     
            )
    }
) 

 

Highlighted
Advocate III
Advocate III

Re: Saving data from powerapps to SP lists person/Group column

Yep, they’ve been tripping over this column type for years. God help you if you’re dealing with multi-value persongroup columns. Its just a cluster #%...
Highlighted
Advocate III
Advocate III

Re: Saving data from powerapps to SP lists person/Group column

The reason you can’t find tons of examples on google for different scenarios other than the most basic use case is that ppl simply cannot get this column type to work in any advanced scenarios.
Highlighted
New Member

Re: Saving data from powerapps to SP lists person/Group column

Thank you - this works perfectly

Highlighted
Frequent Visitor

Re: Saving data from powerapps to SP lists person/Group column

Hi guys, this is really interesting to work on powerapps, I am stuck on a client project where there are two sp lists, requests and processor, there is a combobox attached as office365users of requests list in powerapp, and what I am trying to do is to save combobox person to another list named processor. I appreciate your help on this.
Highlighted
Frequent Visitor

Re: Saving data from powerapps to SP lists person/Group column

Hi all,

 

sorry to reply to such an old topic, but I wasn't able to find something similiar.

 

Adding a user is working fine with your solutions but how do i add GROUPS to the SharePoint List? I mean.. the column in the list is designed for adding Users or Groups but i cann't get it working..

 

I have a ComboBox with something like "'Office365-Gruppen'.ListOwnedGroups().value.displayName" for choosing a group, but i can't add that into the SharePoint List with a Patch-Statement. Any Suggestions?

Highlighted
Frequent Visitor

Re: Saving data from powerapps to SP lists person/Group column

This solution worked for me. Thanks

Highlighted
Frequent Visitor

Re: Saving data from powerapps to SP lists person/Group column

Hi @fher:  I found a fix that appears to be working for O365 groups, as follows:

Instead of this:  

Claims: "i:0#.f|membership|" & "someO365group@yourdomain.com"

 

Try this:

Claims: "someO365group@yourdomain.com"
 
So just remove the front part of that claims attribute.  Now, mind you I have no idea why this worked, but it did. 😉
 
Highlighted
Helper IV
Helper IV

Re: Saving data from powerapps to SP lists person/Group column

I realise this is an old thread but my issue is very much like what is happening here for some people. With my particular Patch, it was working just fine, until today, when I started getting an error - Specified User could not be found etc.

 

The below image is taken after I made some minor changes being the removal of the reference to TextInput2_36.Text from the Department, Email, JobTitle and Picture fields, and the same for the second part of the patch for Buddy.

 

person patch issue.png

Powerapps FlowChecker is saying:
Patch(source, record, update, update, update, update, ...)

update: The update that needs to be patched to the given record

 

What I am trying to do, is through a gallery, patch a textinput field (as per above) which includes the person field AssignedTo. This is not working, yet when I update the AssignedTo via a form on the app, this works. But the second part of this, is that a flow is triggered, to identify when a job has been assigned based on the DisplayName of the person in the AssignedTo field, and then fill in the AssignedToEmail field. When I fill out the AssignedTo field via the form, my Flow is not able to populate the AssignedToEmail field - this was working previously.......

 

Any help would be much appreciated as I was supposed to be putting this app into full use before weeks end. With this broken, it won't be usable.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,535)