I have created two virtual tables (using the same Odata V4 Data Source connecting to Azure Devops): "WorkItems" and "Projects". They both fetch fine.
Now I want to try to link these tables together with a one-to-many relationship; In the data source, a WorkItem is related with a Project
[
{
"WorkItemId": 2,
"Project": {
"ProjectId": "63514016-7f57-4796-bb5f-ebd85cd58620"
}
},
{
"WorkItemId": 3,
"Project": {
"ProjectId": "63514016-7f57-4796-bb5f-ebd85cd58620"
}
},
{
"WorkItemId": 7,
"Project": {
"ProjectId": "3c84cdd5-5e94-400c-947b-6bb587d132c2"
}
}
]
I have tried to add a LookUp field "Project" in the "WorkItem" table, that points to the "Projects" table, but when I try to fetch the "WorkItem" virtual table with that column, I get an error "Object reference not set to an instance of an object"
{
"error": {
"code": "0x80040224",
"message": "Object reference not set to an instance of an object.",
"@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040224&client=platform",
"@Microsoft.PowerApps.CDS.TraceText": "\r\n[Microsoft.Xrm.DataProvider.Odata.V4.Plugins: Microsoft.Xrm.DataProvider.Odata.V4.Plugins.ODataRetrieveMultiplePlugin]\r\n[68a8f98b-2a40-ef11-8409-000d3ab83ecd: External plug-in implementation]\r\n\r\n\t\r\n\tQuery to OData source : https://analytics.dev.azure.com/xxxx/_odata/v4.0-preview/WorkItems\r\n\t\r\n",
"@Microsoft.PowerApps.CDS.InnerError.Message": "Object reference not set to an instance of an object."
}
}
Is there any other way to link two virtual tables, using their navigation properties?
