Can't add Microsoft Entra ID to the Dataverse table

[VMK]

Hi everyone,

I have a Dataverse table that contains Microsoft Entra ID column.

I am now trying to add a new row to the table using Power Automate but Microsoft Entra ID filed is not accepting the user ID and throws a error:

{

  "error": {

    "code": "0x80060888",

    "message": "URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL."

  }

}

[harshdeol]

Hi @VMK , Instead of passing the Entra ID directly, please use the following syntax:

/aadusers(outputs('Get_user_profile_(V2)')?['body/id'])

Since the Sales Person field is a lookup field to the "Microsoft Entra ID" table, you cannot update it directly. You need to pass the Unique Identifier of that record(which is the same as the Entra ID in this case).

Please try and let me know if you face any issues further.

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol

[VMK]

Hi @harshdeol ,

Many thanks for your reply. I tried 

/aadusers(outputs('Get_user_profile_(V2)')?['body/id'])

and flow checker returned a error:

The power flow's logic app flow template was invalid. The template language expression '/aadusers(outputs('Get_user_profile_(V2)')?['body/id']) ' is not valid: the string character '/' at position '0' is not expected.

If I use it with no / the flow returns a error:
InvalidTemplate. Unable to process template language expressions in action 'Add_a_new_row_to_FMS_Installations' inputs at line '0' and column '0': 'The template function 'aadusers' is not defined or not valid.'.

Can you please help?

[harshdeol]

Hi @VMK , Can you please confirm the Sales Person is a Lookup column from Entra Id table?

If yes, please type the /aadusers() manually and then with the parenthesis (), add the Dynamic value of the "Id" from previous Action. See previous Image. It should look similar to this if you copy all values in Notepad.

/aadusers(@{outputs('Get_user_profile_(V2)')?['body/id']})

-----------------------------------------------------------------------------------------------------------------
If your question got an answer, please click "Accept as Solution "✅, If you liked my answer, please hit the "thumbs-up" 👍button.

Thank you,
Harsh Deol

[VMK]

@harshdeol ,

sorry for the late reply. I have tried what you suggested. But I still have a error. It looks like the plugin was not installed correctly.

"@Microsoft.PowerApps.CDS.InnerError.Message": "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: \r\nErrorCode: 0x80040216\r\nMessage: AccessToken not found. Please make sure plugin is registered as synchronous and not called with app credentials.\r\nTimeStamp: 2024-06-26T15:46:17.0000000Z\r\nOriginalException: Microsoft.Crm.CrmException: AccessToken not found. Please make sure plugin is registered as synchronous and not called with app credentials.\r\n   at Microsoft.Crm.ObjectModel.OboTokenProvider.<>c__DisplayClass13_0.<GetOBOToken>b__0()\r\n   at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n   at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n   at Microsoft.Crm.Sandbox.Service.PluginSecureStoreServiceProvider.<>c__DisplayClass39_0.<OnBehalfOfTokenServiceProviderAcquireToken>b__0()\r\n   at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult...)."