web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Value must be a data e...
Power Apps
Unanswered

Value must be a data entity record

(0) ShareShare
ReportReport
Posted on by 8

I have a two-way lookup in my powerapp between two Combo Boxes.

 

The 'On change' of Field1 is 

Set(DesVar,LookUp('Table', 'code' = (Field1.Selected.'code'), 'description'))

and 'default selected items' of field 1 is:

Table({Value:CodeVar})

 

and field 2:

Set(CodeVar, LookUp('Table', 'description' = (Field2.Selected.'description'), 'code'))

and 'default selected items' of field 2 is:

Table({Value:DesVar})

 

This is working as intended- the user can choose a Code from Field 1, and field 2 will populate automatically with the corresponding Des, and visa-versa.

 

However the issue is occurring when I try and save the form, and I get the error 

'Value must be a data entity record' under field 1 (which is being patched to the table- field 2 is purely front end to help the user).

 

I'm not sure what is going wrong here- can anyone advise?

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @m-1 ,

    See the following article, I think you might be setting the field in this location on the save vs. relationship to the full record.

    https://nishantrana.me/2022/12/19/fixed-value-must-be-a-data-entity-record-error-in-power-apps/ 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard