Dataverse List rows AAD - Error AccessToken not found

(2) Share

Report

Posted on by Silvia Innamorati

Hi everyone,

I'd like to extract AAD Users list with Dataverse List rows. I noticed that the type of this table is virtual.

With XRMTOOLBOX I can read this table but in Power Automate, with List Rows I had this 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-09-07T10:59:49.0000000Z
OriginalException: Microsoft.Crm.CrmException: AccessToken not found
at Microsoft.Crm.ObjectModel.OboTokenProvider.<>c__DisplayClass5_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.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, IEnumerable`1 additionalCustomProperties)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TRes...).

I don't know how to managed this issue.

Any suggestion?

This is my flow:

Thanks in advance

Silvia Innamorati

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Rodrigo Hentz on at

Like (0)

Report

Hi @sinnamora how are you?

@sinnamora regarding your questions, as documented at Announcing the AAD User Virtual Table – Find and add any AAD user to your records. | Microsoft Power Apps unfortunately, at this time, AAD User is not currently available for Automate. This is planned for a future release.

API information for the AAD User table can be found here.

Please let me know if you have any questions or concerns about the solution provided.

Best regards.

Rodrigo Hentz

Microsoft Power Platform Support Engineer

Was this reply helpful? Yes No
AgileXRM 16 on at

Like (4)

Report

Hi,
Any news about the "...planned for a future release" please?
Thanks

Was this reply helpful? Yes No
Lenny3 46 on at

Like (4)

Report

I know this is an old post, but I came across it because I was getting the same error when trying to get an AAD User row by ID. For anyone else that stumbles across this thread, this post contained the solution that worked for me: https://powerusers.microsoft.com/t5/Building-Flows/get-aad-user-display-name-from-dataverse-table-in-power-automate/td-p/1745936.

The suggestion was to use the Office365 connector the get an Office User. I'm not sure if there's an equivalent workaround to get more than one user, though.

Was this reply helpful? Yes No
PixieH 6 on at

Like (1)

Report

Thank you for this! This should be the accepted solution.

Was this reply helpful? Yes No