web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Custom Data Entity Cus...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

Custom Data Entity Custom Field

(1) Share

Report

Report

Posted on by RB-14081716-0

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)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 235,796 Most Valuable Professional on at

Like (1)

Report

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?

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

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

#1

DAnny3211 433

#2

Abhilash Warrier 137 Super User 2025 Season 2

#3

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans