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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

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

Virtual Entity - Parent/Child with Integer as Identity not working

(1) ShareShare
ReportReport
Posted on by 38
I have successfully created the a Virtual Table for the entity "DevOps Work Item", using a Odata V4 Data provider.
 
Now I am trying to incorporate the "Parent Work Item" concept.
The datasource structure is as following (only the relevant part):
 
[
    {
        "WorkItemId": 426,
        "ParentWorkItemId": null
    },
    {
        "WorkItemId": 427,
        "ParentWorkItemId": 426
    }
]
 
As you can see, the WorkItem ID is an integer. However, in the virtual table that ID is somehow converted to a GUID ( 426 = 1aa, 427 = 1ab)
 
 
When I try to add a LookUp field to the same table, using the external name "ParentWorkItemId" , and try to fetch the data, I get the error:
 
Type mismatch of the external attribute of type System.Nullable`1[System.Int32] expected a 'System.Nullable`1[[System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]' value.
 
I understand that the system receives an Integer and that it cannot match it with the GUID that it expects on the "parent". But this leaves me with the question: How can I link these parent/child, either using both the INTEGER value, or both using the GUID value? Or is there another way to get around this?
 
Best regards,
Koen
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
ManoVerse Profile Picture

ManoVerse 55 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans