Power Platform Community Forum Thread Details

Hi all,

I am trying to assign a task to multiple users at a time and create separate records in the Sharepoint list.

This is what I am trying to do:

From Power App,

Task (Text input): Task 1

Description (Text input): Description 1

Assignee (Combo Box): Assignee 1, Assignee 2

After submitting, patch the SharePoint list,

Task	Description	Assignee
Task 1	Description 1	Assignee 1
Task 1	Description 1	Assignee 2

My initial approach is using Combo Box to select the assignees (More than 1), then patch the SharePoint list with the result along with the other texts. However, using ComboBox1.Selected.DisplayName only gives me the result of the latest selected result from the combo box instead, which causes the following in the Sharepoint list:

Task	Description	Assignee
Task 1	Description 1	Assignee 2
Task 1	Description 1	Assignee 2

May I know how do I solve this issue? Really appreciate your help.

@WarrenBelz @LaurensM @Drrickryp @BCBuizer @cha_cha @RandyHayes

Categories:

Building Power Apps

Hi @englcc ,

Something like this should do it (assuming Assignee is a Person field)

Patch(
 SPListName,
 ForAll(
 ComboBoxName.SelectedItems As aPatch,
 {
 Task: TaskBoxName.Text,
 Description: DescriptionBox.Text,
 Assignee:
 {
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims: "i:0#.f|membership|" & Lower(aPatch.Email),
 Department: "",
 DisplayName: aPatch.DisplayName,
 Email: aPatch.Email,
 JobTitle: "",
 Picture: ""
 }
 )
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps