You’re offline. This is a read only version of the page.
284
Hello guys. I have the following Problem.
I want to parse data from SharePoint to Dataverse and I'm stuck with the Person field.
In Dataverse, I have a LookUp Column to AAD Users. '
In my Flow I filter like this:
But I always get a Syntax error at Position 54.
I tried List the rows without filter....then i got a weird CRM Dynamics Error
Share
ReportSystem.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: AccessToken not found (Fault Detail is equal to Exception details:
ErrorCode: 0x80040216
Message: AccessToken not found
TimeStamp: 2022-10-25T12:34:42.0000000Z
OriginalException: Microsoft.Crm.CrmException: AccessToken not found
at Microsoft.Crm.ObjectModel.OboTokenProvider.<>c__DisplayClass8_0.<GetOBOToken>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
at Microsoft.Crm.ObjectModel.OboTokenProvider.GetOBOToken(Guid organizationId, IEnumerable`1 scopes)
at Microsoft.Crm.Sandbox.Service.PluginSecureStoreServiceProvider.<>c__DisplayClass37_0.<OnBehalfOfTokenServiceProviderAcquireToken>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEn...).Then I thought, maybe AAD Users is something I can't access so i tried users.
First this
'internalemailaddress' eq '@{items('Apply_to_each')?['Mitarbeiter/Email']}'With the following error :
The left side of the 'Equal' operator must be a property of the entity.Then i tried this
'internalemailaddress' eq @{items('Apply_to_each')?['Mitarbeiter/Email']}With an syntax error at position 57.
As I am new to Dataverse im kind of stuck here how i can get the user to pach it in 'Update a row' or 'Add a new row'.
Can someone help me please?
Kind regards
Ricco
Hi @RiccoHipp1903 ,
The reason for this problem is:
Here you need to use the logical name of [internalemailaddress]
Like this:
Here is a test for your reference:
Best Regards
Cheng Feng
All responses (
Answers (
