cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Madders
Level: Power Up

Binding a lookup field

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ali_Nawaz
Level: Powered On

Re: Binding a lookup field

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

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Binding a lookup field

Ali_Nawaz
Level: Powered On

Re: Binding a lookup field

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

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,333)