Power Automate

Unable to query Microsoft Entra IDs dataverse table

(2) Share

Report

Posted on by _sourcecod3_

407

Hi everyone,

I'm trying to run a query against the Microsoft Entra IDs Dataverse table, but I keep getting the following error:

Microsoft Entra IDs table 2.png

System.ServiceModel.FaultException`1[Microsoft.Xrm.Sdk.OrganizationServiceFault]: AccessToken not found. Please make sure plugin is registered as synchronous and not called with app credentials. (Fault Detail is equal to Exception details: 
ErrorCode: 0x80040216
Message: AccessToken not found. Please make sure plugin is registered as synchronous and not called with app credentials.
TimeStamp: 2024-05-29T13:47:40.0000000Z
OriginalException: Microsoft.Crm.CrmException: AccessToken not found. Please make sure plugin is registered as synchronous and not called with app credentials.
 at Microsoft.Crm.ObjectModel.OboTokenProvider.<>c__DisplayClass13_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__DisplayClass39_0.<OnBehalfOfTokenServiceProviderAcquireToken>b__0()
 at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult...).

Any ideas on how to bypass this?

Thanks

Categories:

General topics

I have the same question (2)

All responses (8)

Answers (0)

Sort by

_sourcecod3_ 407 on at

Like (0)

Report
Copy link

Link copied!

Does anyone have another approach to retrieve data from this table using power automate?

2 people found this reply helpful.

Was this reply helpful? Yes No
Rusty_VanSandt 7 on at

Like (0)

Report
Copy link

Link copied!

No, I wish someone would let us know how.😩

Was this reply helpful? Yes No
Rusty_VanSandt 7 on at

Like (0)

Report
Copy link

Link copied!

I am having the same issue.

Was this reply helpful? Yes No
Rusty_VanSandt 7 on at

Like (1)

Report
Copy link

Link copied!

Try "Get user profile (V2)".

Was this reply helpful? Yes No
_sourcecod3_ 407 on at

Like (1)

Report
Copy link

Link copied!

Hi @Rusty_VanSandt, I don't want to use the user profile connector or doing an API call to graph because the flow has a lot of queries and adding an api call would slow it down drastically.

Was this reply helpful? Yes No
foxpower 17 on at

Like (0)

Report
Copy link

Link copied!

I also get this same error when I am listing rows from a Dataverse table which has a lookup column to the Microsoft Entra ID Dataverse table, and I am trying to expand that column.

Very keen for a way around this!

Was this reply helpful? Yes No
Suggested answer

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

This does not look possible to achieve .. the way around it , is to use the the Get User Profile

Was this reply helpful? Yes No
Suggested answer

UU-21041832-0 21 on at

Like (0)

Report
Copy link

Link copied!

So I was able to find a way around this. I used invoke HTTP request action in Power Automate.

Was this reply helpful? Yes No