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!

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 231,493 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?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2

Martin Dráb 231,493 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans