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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Virtual Entity - Paren...
Power Apps
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 601
(Crossposting from Dynamics Community : Virtual Entity - Parent/Child with Integer as Identity not working (dynamics.com))
 
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)
  • Shashank Bhide Profile Picture
    946 Moderator on at
    ADO workitems are based on integer primary keys, however Dataverse tables MUST have GUID primary keys, so possibly you need to modify the ADO template and include a GUID field and find a way to automatically add a new GUID to that and use that as an alternate key IMO. 
     

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 Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard