Binding a lookup field

[Madders]

Hi Guys,

Looking to bind a lookup field I have created to D365 CE.

I manage to create the field and have the list of names drop down, but when I go to submit the form, I get the following error message:

"Value must be a data entity record"

I have added the correct databases to the PowerApp.

Any help would be greatful.

Thanks

[v-yuxima-msft]

Hi @Madders ,

Do you want to save lookup field into entities?

Could you please reference this:

https://powerusers.microsoft.com/t5/Creating-Apps/Dynamics-365-Look-up-field-update/m-p/198429#M6620

https://powerusers.microsoft.com/t5/General-Discussion/Form-not-saving-with-Dynamics-365-lookup-fiel...

Best Regards.

Yumia

[Ali_Nawaz · Accepted solution]

Hi, 

Try this formula.
Place the formula in the Update property of your dropdown datacard (Lookup field coulmn datacard).  
LookUp(Table_Oppotunities,Project = DataCardValue3.Selected.Project)

Table_Oppotunities  = Dat Source
Project = Column Name
DatacardValue3 = DatacardName


Regards, 
Ali Nawaz