You’re offline. This is a read only version of the page.
Announcements
5
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
Hi @englcc ,
Something like this should do it (assuming Assignee is a Person field)
Share
Report
All responses (
Answers (
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
