Answered

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:

General Questions

All responses (5)

Answers (1)

Verified answer

StretchFredrik 2,650 Super User 2025 Season 1 on at

Like (0)

Report

Re: Patching Combobox to Person Column

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 😃
jed76 on at

Like (0)

Report

Re: Patching Combobox to Person Column

Yes I realised that just after I posted! Many thanks.
StretchFredrik 2,650 Super User 2025 Season 1 on at

Like (0)

Report

Re: Patching Combobox to Person Column

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

Like (0)

Report

Re: Patching Combobox to Person Column

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?
StretchFredrik 2,650 Super User 2025 Season 1 on at

Like (0)

Report

Re: Patching Combobox to Person Column

Person columns expect the following format:

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