cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bloodoff
Level 8

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

At least it's working Smiley Happy 

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

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

 

PhilD
Level 8

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),
                {
                    DisplayNameSmiley Very HappyisplayName,
                    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:""
                }     
            )
    }
) 

 

bdc604
Level 8

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 #%...
bdc604
Level 8

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.
jerrycote2536
Level: Power Up

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

Thank you - this works perfectly

Highlighted
fahad
Level: Powered On

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.
fher
Level: Powered On

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?

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 280 members 4,598 guests
Please welcome our newest community members: