Power Platform Community Forum Thread Details

Can't use Webapi to expand a lookup column of a virtual table

Hello all,

I'm building a website and I use both SQL and Dataverse as database. For dataverse, I use "contact" and "account" tables so that I can manage the contact- and account-type table permissions.

For now I have created two virtual tables from SQL tables. Both tables have one lookup column that links them to "account" table in the Dataverse. I am able to perform GET and PATCH operations via webapi on both virtual tables including the lookup columns. However, when I try to perform GET operation, where I also expand data of the lookup column, I always receive this error message:

{
"error": {
"code": "9004010D",
"message": "Common Data Service error occurred.",
"cdscode": "0x80040224"
}
}

This is the url I use "/_api/xxxx_my_virtual_tables?$expand=xxxx_Organization($select=name)"

"xxxx_Organization" is the Schema name of the look up column that is linked to the account table.

I tried it with other Dataverse tables and there was no problem. I only get the error when I try it with virtual tables. Is this a known limitation? Did I make any mistake or is there any way to work around it so that I can get the value of the primary column of the account table?

Thanks for your help in advance.

Categories:

Customize & extend

Quick Links