Microsoft Dynamics 365 | Integration, Dataverse...

Inserting data in Power Apps entity using Common Data Service

(0) Share

Report

Posted on by Power Platform Comm...

Hi Team,

We are consuming Common Data Service using Azure AD from C# Console Application to insert data in Power Apps Entity

1. We are trying to access Power Apps entities from C# Console App through Common Data Service.

2. We have registered the app on Azure AD.

3. We have the ClientID, TenantId, but when we try to insert the data into Power Apps entity using Common Data Service, we get the following error :

AADSTS65001: The user or administrator has not consented to use the application with ID '{client-id}' named '{application created in Azure AD}'. Send an interactive authorization request for this user and resource.

We have user consent in Azure AD app but when we try to access token, we still get the above error.

When I run this link in browser :

https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize?client_id={client-id}&response_type=code&redirect_uri={redirect_uri}&scope={scope}&prompt={prompt}

I replace the tenant-id, client-id, redirect_uri, scope and prompt, but I get "Need admin approval" popup for my work email address. Is there any other solution apart from tenant admin giving approval.

I have attached word document to explain what I am doing and what may I be missing.

Please help in addressing this issue.

Thanks,

Ashish Dhar

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Linn Zaw Win 3,407 on at

Like (0)

Report

Is your work email address account has the Dynamics 365 administrator or Power Platform administrator role in Microsoft 365 admin center?

Please follow the steps 5-8 from the tutorial below to allow the application to access the API.

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/walkthrough-register-app-azure-active-directory

After that, create the application user in the Settings area and

https://docs.microsoft.com/en-us/power-platform/admin/create-users-assign-online-security-roles#create-an-application-user

assign the security role to the application user

https://docs.microsoft.com/en-us/power-platform/admin/create-users-assign-online-security-roles#assign-a-security-role-to-a-user

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

in your Azure App, have you added the CDS permissions in the API Permission tab of Azure AD?

After adding permissions then you will need an admin to grant consent on that.

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

you are trying to login with OAUTH? with Application ID you don't need this. using the CDS SDK you can put the application id and tenant id on the connection string and do the authentication

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

Is your work email address account has the Dynamics 365 administrator or Power Platform administrator role in Microsoft 365 admin center?

Please follow the steps 5-8 from the tutorial below to allow the application to access the API.
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/walkthrough-register-app-azure-active-directory
After that, create the application user in the Settings area and
https://docs.microsoft.com/en-us/power-platform/admin/create-users-assign-online-security-roles#create-an-application-user
assign the security role to the application user
https://docs.microsoft.com/en-us/power-platform/admin/create-users-assign-online-security-roles#assign-a-security-role-to-a-user

Was this reply helpful? Yes No
Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

This might help

nishantrana.me/.../

Was this reply helpful? Yes No