Unanswered

Patching Combobox to Person Column

(0) Share

Report

Posted on by jed76

I have a person column in my SP list which I want to be able to patch to from a ComboBox. the ComboBox's ITEMS is using the Choices function which works but when I try and patch back I get that the requested column expects a RECORD but finds a TABLE. Surely if the ComboBox is referring back to the choices in the person column, I should be able to patch data back to the column?

Also, is there a way to set the default item of the combobox to the current item. For example, ThisItem.MyComboBox.SelectedItems......

Many thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Person columns expect the following format:

{
        DisplayName: User().FullName;
        Claims: "i:0#.f|membership|" & User().Email;
        Department: "";
        Email: User().Email;
        JobTitle:"";
        Picture:User().Image
    }

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report

Great. Many thanks. This kind of works but it keeps reverting back to myself rather than the display name I have selected in the ComboBox?

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Yes because i put User() which gets the curret user, switch it to the person object selected in your App 😃

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report

Yes I realised that just after I posted! Many thanks.

Was this reply helpful? Yes No
Verified answer

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Glad I could help you, had the same issue a few months back, its kinda hard to find out specific columns expected formatting.

Take care 😃

Was this reply helpful? Yes No