
Announcements
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?
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/