Answered

Patch a gallery Person combo box to SharePoint using OnChange Function

(0) Share

Report

Posted on by jselman

I have a combo box used as a People Picker within a gallery. I'm trying to patch the person selected to a Person/Group column on a SharePoint list using the OnChange function. My formula is:

Patch(colMetricInformation, ThisItem, {'Person Name': Self.Selected.DisplayName})

However, I receive this error: "The type of this argument 'PersonName' does not match the expected type 'Table'. Found type 'Text'.

How do I overcome this error? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @jselman ,

You should only need this

Patch( colMetricInformation, ThisItem, {'Person Name': Self.Selected} )

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

Was this reply helpful? Yes No
jselman 38 on at

Like (0)

Report
Copy link

Link copied!

Hello and thanks for your response. I get a different error when I change the formula to your suggestion. "The type of this argument 'PersonName' does not match the expected type 'Table'. Found type 'Record'. It was "text", now it's "record". Any ideas?

Was this reply helpful? Yes No
jselman 38 on at

Like (0)

Report
Copy link

Link copied!

Good morning, again. I turned off the "allow multiple selections" function in the SharePoint column and your solution works fine now. Thanks.

Was this reply helpful? Yes No