web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Issues with Patching a...

Power Apps

Answered

Issues with Patching and Polymorphic Lookup

(0) Share

Report

Report

Posted on by deltaformtech

55

I'm using the CDS and custom tables: Customers and Sites.

Sites has a lookup column to Customers and I am having issues patching a record to Sites that references Customers.

Screenshot 1: The form. All fields are directly included in the Patch function on the Save button

Screenshot 2: The ComboBox for Customer has Items set to Customers.Name

The OnSelect of the Save button is set to (line generating error bolded):

Patch(
Sites,
Defaults(
Sites
),
{
Name: Concatenate(SiteStreetTextInput.Text, ", ", SiteCityTextInput.Text, ", ", SitePostalTextInput.Text),
'Street Address': SiteStreetTextInput.Text,
City: SiteCityTextInput.Text,
'Postal Code':SitePostalTextInput.Text,
Customer: SiteCustomerComboBox.Selected
}
);

Screenshot 3: Error text

I am vaguely familiar with polymorphic lookups (IsType/AsType) but unable to mentally wrap my head around what I need to do in this situation.

Greg

Screen Shot 2021-02-11 at 4.47.27 PM.png

Screen Shot 2021-02-11 at 4.46.26 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @deltaformtech ,

At my knowledge, 'customer' column can refer to 'Accounts' or 'Contacts' entity. These two entities are system entities. You could not refer to a custom entity.

If you want to use 'customer' column, I suggest you replace the referenced entity.
I did the test for you.
1\ Add a combo box control 'ComboBox1' and set its Items property to:
Contacts

2\ Add a button control and set its onselect property to:
Patch(Sites,Defaults(Sites),{Name:"11",Customer:ComboBox1.Selected})

3\ Click the button and the result is as follows:

In addition , If you want to refer to custom entity, I suggest you use lookup column.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
deltaformtech 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Wearsky,

I found the source of my issue. I had the Items property of SiteCustomerComboBox set to "Customers.Name" instead of just "Customers". Once I updated that, I was able to Patch the Customers record to a Lookup column in Sites.

Thank you!

Greg

Was this reply helpful? Yes No

Join the conversation