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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Custom Data Entity Custom Field

(1) ShareShare
ReportReport
Posted on by 2
I have created a Custom Data Entity called CustomPurchaseLines. I want a field called 'Project'. The 'Project' value exists on another table called MarkingView. 
I can map the two together by an ID. The problem is there can be multiple IDs in the MarkingView table. I just want to return the first record found. 
 
Anyone have any suggestion on how to do this?
This would be extremely appreciated - thank you! 
I have the same question (0)
  • Martin Dráb Profile Picture
    236,962 Most Valuable Professional on at
    Custom Data Entity Custom Field
    Is it about F&O? (You're asking in D365 general forum.)
     
    Are you sure you don't want to identify a specific record in MarkingView table (by referring to its primary key)? If not, how do you want to pick the right record from all the records with the given ID? Doesn't it suggest a bug in your data model?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 77 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 57 Most Valuable Professional

#3
Anthony Blake Profile Picture

Anthony Blake 43 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans