cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

"expected dataentityrecord for navigation column" message when trying to save a form w lookup field

Hi,

i get the error "expected dataentityrecord for navigation column" when i try to save a form containing combobox referring to a lookup field

(see attachment), this error is in the new version of CDS 2.0, and it did not appear before in CDS1.0

 

thanks

Mohammad

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

I realized my issue - I have two data sources for Users - one is Users and the one from the CDS is Users_1 - once I corrected the data source I was able to get the record created correclty.  One item that I discovered is that I had to put my lookup value for the User entity in a variable and can't derive it as part of the formula (User().FullName).  Here is what finally worked.

 

Patch(PowerAppUserPreferencess,Defaults(PowerAppUserPreferencess),
{crcf1_SystemUser:LookUp(Users_1,fullname=UserName)},
{crcf1_Community:LookUp(Communitys,crcf1_communityname="Azure")},
{crcf1_lastlogin:Now()})

I dropped the line for the Option Set value because a value is defined in the CDS as a default and wasn't required here.

View solution in original post

16 REPLIES 16
Highlighted
Community Support
Community Support

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

Would you please share more details about the lookup field, and the entity you used here?

Per my understanding, the message should means for the navigation field, the required data is the dataentity record type.

Have you configured any customization for the lookup field?

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

DId you ever figure out what was causing this? I'm getting the same error and I have no idea why.

Highlighted
Frequent Visitor

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

Same issue. Any updates?

Highlighted
Resolver II
Resolver II

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

I'm receiving the same error - I have an entity with two lookup values (User & Community) - here is the patch command I'm trying to use:

 

Patch(PowerAppUserPreferencess,Defaults(PowerAppUserPreferencess),
{crcf1_SystemUser:LookUp(Users,fullname=UserName)},
{crcf1_Community:LookUp(Communitys,crcf1_communityname="Azure")},
{crcf1_lastlogin:Now()})

I've put this on the 'OnSelect' action of a button to test that it is properly inserting the record.

 

 

Highlighted
Frequent Visitor

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

Your lookup field should come up twice in the list of fields of the Form. One as a combobox, and one as text box. 

Set it up this way:

ComboBox with the list of text values, SelectMultiple to false, and nothing on the "Update" property.

TextBox with the "Default" set to the IDField of the ComboBox's Selected record (Should be a GUID) and the "Update" property of the DataCard set to the TextBox's "Text" property.

When you select an entry on the ComboBox, the TextBox updates it's "Text" to the GUID of the record selected. When you SubmitForm, you are only passing the GUID, not the record.

 

 

Highlighted
Resolver II
Resolver II

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

I realized my issue - I have two data sources for Users - one is Users and the one from the CDS is Users_1 - once I corrected the data source I was able to get the record created correclty.  One item that I discovered is that I had to put my lookup value for the User entity in a variable and can't derive it as part of the formula (User().FullName).  Here is what finally worked.

 

Patch(PowerAppUserPreferencess,Defaults(PowerAppUserPreferencess),
{crcf1_SystemUser:LookUp(Users_1,fullname=UserName)},
{crcf1_Community:LookUp(Communitys,crcf1_communityname="Azure")},
{crcf1_lastlogin:Now()})

I dropped the line for the Option Set value because a value is defined in the CDS as a default and wasn't required here.

View solution in original post

Highlighted
Helper III
Helper III

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

@TGrounds,

 

Thank you so much for your post on your solution. This helped me tremendously this evening. I too suffered from the exact problem you posted.

 

Thankful,

-Tom

Highlighted
Frequent Visitor

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

Hi,

 

My combobox did came up twice in the list of fields.

The problem I have is that DataCard with text value does not have update functionality 😞

 

*the "Update" property set to its own "Text" property.

 

Can you please help me with this? Images in attachment.

 

Highlighted
Frequent Visitor

Re: "expected dataentityrecord for navigation column" message when trying to save a form w

Set the Update property of the DataCard to the "Text" property of the field that has the value "ecfd5e39-8b3f-e611-80e7-00155d7b242e" in your first screenshot...

 

I attached a screenshot where I typed the "Update" property of my DataCard, and set it to the "Text" property of my Text Input field "DataCardValue2".

 

 

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,153)