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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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