Connect to Dataverse to retrieve user

[RiccoHipp1903]

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

System.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

[v-chengfen-msft · Accepted solution]

Hi @RiccoHipp1903 ,

The reason for this problem is:

1. [The left side of the 'Equal' operator must be a property of the entity. ] means that [internalemailaddress] is not the correct name.

Here you need to use the logical name of [internalemailaddress]

Like this:

Here is a test for your reference:

Best Regards

Cheng Feng