Power Apps Patch Error: Owner field polymorphic schema mismatch (Dataverse)

(0) Share

Report

Posted on by JL-20050103-0

Summary of Issue

I’m trying to use Patch() in Power Apps to create a record in a Dataverse table, but I’m encountering persistent errors when setting the Owner field.

The Owner column is the standard Dataverse polymorphic field (can reference a User or Team). Even though my ComboBox is correctly bound to the systemusers table and I’m using .Selected, Power Apps throws schema/type errors when patching.

Typical errors include:

Invalid argument type. Expecting a Record value, but of a different schema

Missing column 'Owner' with a type of 'Polymorphic'

The type of this argument '_ownerid_value' does not match the expected type 'Polymorphic'

What makes this confusing:

Other lookup fields (Client, Site Location, etc.) work fine with .Selected

The Owner field behaves differently due to being polymorphic

Even when using LookUp(systemusers, ...), the record is not accepted

Goal:

Simply assign the Owner when creating a record — either:

From a selected user (ComboBox)

Or automatically as the current logged-in user

Core issue:

Power Apps does not accept a standard record for the Owner field, and it’s unclear what the correct structure or best practice is for patching a polymorphic Dataverse field.

Example of Code

Patch(
    'Progress Note',
    Defaults('Progress Note'),
    {
        Type: cboNoteType_3.Selected,
        Description: txtNotes_2.Text,
        'Site Location': cboSite_2.Selected,
        Client: cboClient_2.Selected,
        Owner: cboOwner_1.Selected
    }
)

I have tried radio buttons and various other things to no prevail

Any help would be greatly appreciated

Thanks

Justin

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Vish WR 3,418 on at

Like (0)

Report
Copy link

Link copied!
@JL-20050103-0

The Owner field in Dataverse is polymorphic it can be a User or a Team so Power Apps won't accept a plain .Selected record like other lookups. You need to use LookUp against the systemusers table directly.

If you just want to set it to the current logged-in user, skip the combobox entirely:

Owner: LookUp(systemusers, 'Primary Email' = User().Email)

If you want to use the combobox selection:

Owner: LookUp(systemusers, systemuserid = cboOwner_1.Selected.systemuserid)

Also make sure your combobox is pulling from the systemusers Dataverse table, not a local collection or SharePoint source.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Vish WR 3,418 on at

Like (0)

Report
Copy link

Link copied!

@JL-20050103-0

Wanted to check if you are able to resolve your problem? Let me know if you need any clarification

When replying, please don't forget to mention my userid so that it will be notified

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No