Unanswered

Patching from one SharePoint List person field to another SharePoint List person field

(1) Share

Report

Posted on by tara123

In a Form (ProjectTrackerForm) with data source as 'Workbook' SharePoint List.

Then inside this form, I have a Combo Box (TaskingLeadComboBox) which is a Multi-Person Field which connects to another SharePoint list 'StaffList' and pulls values from a column called 'Person'.

I want to save the selected 'Person' field values from the Combo Box to the Workbook SharePoint List column called 'Tasking Lead' (Also a multi person field).

This is the patch I've been working around which I got from a video from April Dunnam on patching person fields, but it keeps giving me various errors saying 'Mail' and 'DisplayName' aren't recognised and 'Tasking Lead does not match expected type 'table'. Found type record'.

Patch(
    Workbook, 
    Defaults(Workbook), 
    {
        Title: DataCardValue37.Text,
        'Tasking Lead': {
                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                Claims: TaskingLeadComboBox.Selected.Mail,
                Department: "",
                DisplayName: TaskingLeadComboBox.Selected.DisplayName,
                Email: TaskingLeadComboBox.Selected.Mail,
                JobTitle: "",
                Picture: ""
        }
    }
)
 
MS Copilot isn't helping much & I feel like I've searched everywhere! 
 
Any help is massively appreciated!
Thanks!
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (2)

Report
Hi @tara123

The issue you have is, you are trying to pass in a Single record, instead of a Table. Even if you only have a single person to add, you still have to treat it like a Table so that it works.

Try wrapping it like this

'Tasking Lead': Table({ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: TaskingLeadComboBox.Selected.Mail, Department: "", DisplayName: TaskingLeadComboBox.Selected.DisplayName, Email: TaskingLeadComboBox.Selected.Mail, JobTitle: "", Picture: "" })

Was this reply helpful? Yes No
tara123 22 on at

Like (0)

Report

Ah thanks for the reply @Michael E. Gernaey, it still had errors with that but I since realised my first SharePoint list was a single person column which I can't change to multiple as it's used by other apps so I've changed my Workbook SharePoint list to a single person column too and this formula works for the patch & is updating my relevant SharePoint List for the item selected:

Patch(

Workbook,

WorkbookGalleryWB.Selected,

{

'Tasking Lead': {

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims: "i:0#.f|membership|" & TaskingLeadComboBox.Selected.Value,

Department: "",

DisplayName: TaskingLeadComboBox.Selected.Value,

Email: TaskingLeadComboBox.Selected.Value,

JobTitle: "",

Picture: ""

}

}

)

However, I am struggling to get the combo box to display the selected users after submitting then going back into the gallery item. I have updated the update property of the card to:

{

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims: "i:0#.f|membership|" & TaskingLeadComboBox.Selected.Value,

Department: "",

DisplayName: TaskingLeadComboBox.Selected.Value,

Email: TaskingLeadComboBox.Selected.Value,

JobTitle: "",

Picture: ""

}

and Default selected items in the combo box to:

[ThisItem.'Tasking Lead']

and Default in the combo box & card to:

ThisItem.'Tasking Lead'

but it is not showing me any values when I click into a selected item that I added a user to (but it is showing in the SharePoint list!)

Any help on that would be appreciated.

Thanks

Was this reply helpful? Yes No