cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RiccoHipp1903
Resolver II
Resolver II

Connect to Dataverse to retrieve user

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:

RiccoHipp1903_0-1666765327445.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-chengfen-msft
Microsoft
Microsoft

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:

vchengfenmsft_0-1666848075904.png

 

 

vchengfenmsft_1-1666848075911.png

 

Here is a test for your reference:

 

vchengfenmsft_2-1666848075918.png

 

Best Regards

Cheng Feng

View solution in original post

1 REPLY 1
v-chengfen-msft
Microsoft
Microsoft

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:

vchengfenmsft_0-1666848075904.png

 

 

vchengfenmsft_1-1666848075911.png

 

Here is a test for your reference:

 

vchengfenmsft_2-1666848075918.png

 

Best Regards

Cheng Feng

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,315)