Power Platform Community Forum Thread Details

I have a button in which OnSelect builds a collection and then patches a bunch of information to a SharePoint list.

I'm using clear collect to build the collection of distinct emails called CurrentEmails

ClearCollect(

Emails,

.....);

ClearCollect(CurrentEmails,Distinct(Filter(Emails,Not(IsBlank(Email))),Email));

The column field is called Value

I'm trying to figure out how to patch all the emails in the collection to a SharePoint list multiple person field along with some individual other fields.

My patch formula is as follows:

Patch('SharePointList',
Defaults('SharePointList'),
{Status:{Value:"Submitted"},
'Requested Date':RequestedDate.SelectedDate,
Customer:CustomerSearch.Selected.Customer,
'Customer Address':CustomerSearch.Selected.FullAddress,
'Current Assignments': .......,

'Updated Assignments':........,
Emails:

ForAll(CurrentEmails,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Department: "",
Claims: "i:0#.f|membership|" & Lower(ThisRecord.Value),
DisplayName: Office365Users.UserProfileV2(ThisRecord.Value).displayName,
Email: ThisRecord.Value,
JobTitle: "",
Picture: ""
})
}
)
);