I enabled portal logging, I see this:
2022-11-14T04:39:38,Error,site-82947e8e-66a8-4e36-b559-a7b9c4fdeef9-USe2,5ac5a5,638039975789318341,0,2332,72,"RequestData:{""IsAuthenticated"":true,""Tags"":[]}, RequestPath:/_services/entity-grid-data.json/7ccbaf6a-cb63-ed11-9562-000d3a1b97ad, RequestExtension:, SessionId:, UserId:967E6IksbhA5h0mylkMMXBMFbfMMcZaXUkO4RYCgydtKfVMbbMJb5HLZX8kcNMKMgYzsK8RX1YMdPXyaaluVEy8tQhvXpX9ohBWcxe9MAg5JH-EUnmARQmzLDTj1ktV_AfsP3S0yuY1iRCceiQR_0Q2, CorrelationId:32cd96ca-cfb3-4fca-8e1b-615819c437cf, Elapsed:729.3611, 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) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36, HandlerName:System.Web.Mvc.MvcHandler, HandlerExecuted:False, VaryByCustom:, MemberName:TraceError, SourceFilePath:S:\Framework\Adxstudio.Xrm\Core\Telemetry\TelemetryActionFilterAttribute.cs, SourceLineNumber:106, ExceptionMessage:Exception of type 'Microsoft.Xrm.Sdk.Data.Exceptions.InvalidQueryException' was thrown.
System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at Site.Areas.Portal.Controllers.EntityGridController.GetData(ViewConfiguration viewConfiguration, String sortExpression, String search, String filter, String metaFilter, Int32 page, Int32 pageSize, Boolean applyRecordLevelFilters, Boolean applyRelatedRecordFilter, String filterRelationshipName, String filterEntityName, String filterAttributeName, Nullable`1 filterValue, Boolean overrideMaxPageSize, IDictionary`2 customParameters, Int32 timezoneOffset, Boolean checkPermissionSet, String pcfFilter) in S:\Samples\MasterPortal\Areas\Portal\Controllers\EntityGridController.cs:line 264
at Site.Areas.Portal.Controllers.EntityGridController.GetGridData(String base64SecureConfiguration, String sortExpression, String search, String filter, String metaFilter, Int32 page, Int32 pageSize, Int32 timezoneOffset, String pcfFilter) in S:\Samples\MasterPortal\Areas\Portal\Controllers\EntityGridController.cs:line 80
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)
mscorlib
, EventData:Exception: Exception of type 'Microsoft.Xrm.Sdk.Data.Exceptions.InvalidQueryException' was thrown. was found at controller: EntityGrid and action: GetGridData, Category:Exception, ErrorCategory:ApplicationError",8000001c-0001-fe00-b63f-84710c7967bb
It doesn't seem possible to show anything from AAD User as a related table in a view on Power Pages.
Interestingly, when I go to 'data' within my site in power pages and look at the view I'm trying to show to authenticated users, no AAD User related columns show any info but if I add the lookup column to the view I can see the users name. If I modify that view to show the lookup field but no related table fields (and save/publish) then go to the site it won't error but also won't show what is in the lookup field.
