Hello,
i want to load user- and company information from Azure Active Directory and license data from Microsoft 365 Admin Center using Power Automate and store them in Microsoft Dataverse.
I have tried it with Http Connector using Microsoft graph API, but i always get errors, eg.:
{
"error": {
"code": "BadRequest",
"message": "Write requests (excluding DELETE) must contain the Content-Type header declaration.",
"innerError": {
"date": "2024-07-24T13:45:31",
"request-id": "c6782682-1ec6-460a-91ba-3edc8158b0ed",
"client-request-id": "c6782682-1ec6-460a-91ba-3edc8158b0ed"
}
}
}
Does anyone have a working solution for case? How can i load information from Azure AD and Microsoft 365 Admin Center?
Here the steps i did in Power Automate which unfortunatelly doesn't work:
-
Create or Open Your Flow:
- Go to Power Automate.
- Create a new flow or open your existing flow where you are trying to retrieve the license details.
-
Configure the HTTP Action for Access Token:
- Add a new HTTP action to obtain the access token.
- Configure it as follows:
- Method:
POST - URL:
https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token- Replace
{tenant-id}with your Azure tenant ID.
- Replace
- Headers:
json
{
"Content-Type": "application/x-www-form-urlencoded"
} - Body:
plaintext
client_id=YOUR_CLIENT_ID&scope=https%3A%2F%2Fgraph.microsoft.com%2F.default&client_secret=YOUR_CLIENT_SECRET&grant_type=client_credentials
- Method:
-
Extract the Access Token:
- Add a "Parse JSON" action to parse the response from the token request.
- Use the following schema:
json
{
"type": "object",
"properties": {
"access_token": {
"type": "string"
}
}
}
-
Configure the HTTP Action for License Details:
- Add another HTTP action to get the license details.
- Configure it as follows:
- Method:
GET - URL:
https://graph.microsoft.com/v1.0/users/{user-id}/licenseDetails- Replace
{user-id}with the actual user ID or dynamic content.
- Replace
- Headers:
json
{
"Authorization": "Bearer @{body('Parse_JSON')?['access_token']}",
"Content-Type": "application/json"
}
- Method:
Thank you and best Regards
Lukas
414
