Unanswered

Relation between virtual table (sharepoint) and Account table leeds to error with Account Access type permission

(0) Share

Report

Posted on by Sylvain73

Hi everyone,

I hope someone can help me.

I have a configured virtual table "TestClientProjects" connected to a sharepoint List.
This virtual list has a lookup field "Account" related (many-to-one) to the Account table.

In sharepoint the list looks like this:

On my Power Pages website i show the list with a account access type permission.
If I assign a account to the logged in user and open the website I get the following error message:

In the log i get the following message:

2023-09-19T12:16:49,Error,site-237c7-3e38-4860-80a4-07498024d-GEn,ac,6383072269201,0,68,52,"RequestData:{""IsAuthenticated"":true,""Tags"":[]}, RequestPath:/_services/entity-grid-data.json/d76f4-256-ee11-be6e-002213a4, RequestExtension:, SessionId:, UserId:aYBN_Hl8kV6tbdghfrgeigGGqB0PKqaB5BaU98roSOfby7-qBS1zL_u_CtNvLcJnCRNEggFDZGFgjhtgz3eQS4bjB-NOeQy-cuu3034cXu1zevUO7rPgsw2, CorrelationId:222c1a39-d332-46d7-ba97-703443f7f026, Elapsed:7936.9627, RequestMethod:POST, RequestContentType:application/json; charset=utf-8, RequestAccept:application/json, text/javascript, */*; q=0.01, RequestCacheControl:, UserAgent:Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/117.0, HandlerName:System.Web.Mvc.MvcHandler, HandlerExecuted:False, VaryByCustom:, MemberName:TraceError, SourceFilePath:C:\__w\1\s\Framework\Adxstudio.Xrm\Core\Telemetry\TelemetryActionFilterAttribute.cs, SourceLineNumber:106, ExceptionMessage:APIM request was not successful : StatusCode : BadRequest, Reason : Bad Request, Response from APIM: {
""status"": 400,
""message"": ""The expression \""Account eq bce487df-2d56-ee11-be6e-002248d813a4\"" is not valid. Creating query failed.\r\nclientRequestId: \r\nserviceRequestId: bff8dba0-b07c-7000-3851-a4bdc887f5b1""
}
System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]

Best regards,
Sylvain

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Akah Mandela 445 on at

Like (0)

Report
Copy link

Link copied!
The most likely cause of this error is that the Account ID does not exist or Account ID is correct, but the user does not have permission to access the Account.
To resolve this error, you can try the following:
Verify that the Account ID exists.
Verify that the user has permission to access the Account. You can do this by checking the user's security role.

Was this reply helpful? Yes No
Sylvain73 6 on at

Like (0)

Report
Copy link

Link copied!

@mandela, thank-you for your help.
I checked that the Account ID exists and the user's security role.
I also created an other "non-virtual" table in Dataverse and put the list with a account access type permission on the webpage. In this "non-virtual" table the access control works as expected and I only see the rows connected to the users account.

Thus, the error must be related with the virtual table.

Does anyone know what is wrong with the query expression:
""message"": ""The expression \""Account eq bce487df-2d56-ee11-be6e-002248d813a4\"" is not valid. Creating query failed.\r\nclientRequestId: \r\nserviceRequestId: bff8dba0-b07c-7000-3851-a4bdc887f5b1""
}

Thanks in advance.

Was this reply helpful? Yes No