Microsoft OneDrive action integration
Use the Microsoft OneDrive action connector to manage OneDrive files, folders, and Excel workbooks directly in Amazon Quick through natural language.
Amazon Quick supports multiple authentication methods for Microsoft OneDrive. Choose the method that best fits your organization's security requirements.
-
Default OAuth app – Uses an AWS-managed OAuth application. No additional credentials are needed. Users authenticate directly with their Microsoft account.
-
Custom OAuth app – Uses a customer-managed application registered in Microsoft Entra. This option gives your organization full control over the OAuth configuration. Users authenticate on behalf of a signed-in user (delegated permissions).
-
Service-to-Service OAuth – Uses client credentials for server-to-server authentication without user interaction (application permissions). Suitable for automated workflows.
For more information about the authentication methods that Amazon Quick supports, see Authentication methods.
Before you begin
Make sure you have the following before you set up the integration.
-
A Microsoft 365 account with OneDrive access.
-
For Custom OAuth app or Service-to-Service OAuth: Access to the Microsoft Entra admin center
on the Microsoft website with at least Application Developer permissions. -
For subscription requirements, see Set up integrations in the console.
Configure Microsoft Entra
If you are using Default OAuth app authentication, skip this section and proceed to Setting up the connector in Amazon Quick.
Before you configure Amazon Quick, create an app registration in Microsoft Entra. Complete all of the following steps in Entra before moving to the Amazon Quick console.
For more information about app registrations, see Register an application with the Microsoft identity platform
Register the application
-
Open the Microsoft Entra admin center
. -
In the left navigation, choose Entra ID, then choose App registrations.
-
Choose New registration.
-
For Name, enter a descriptive name for your integration.
-
For Supported account types, choose Accounts in this organizational directory only.
-
For Redirect URI, select Web and enter
https://. Replace{region}.quicksight.aws.amazon.com/sn/oauthcallback{region}with the AWS Region where your Amazon Quick instance is deployed. -
Choose Register.
-
On the overview page, copy the Application (client) ID and Directory (tenant) ID. You need these values for the Amazon Quick configuration.
Create a client secret
Amazon Quick needs a client secret to authenticate with Microsoft Entra. This secret acts as a password for the app registration.
-
From your app registration, choose Certificates & secrets.
-
Choose New client secret.
-
Enter a description and choose an expiration period.
-
Choose Add.
-
Copy the Value immediately. This value is only displayed once.
Important
Copy the secret Value, not the Secret ID. The Value is the longer string used for authentication.
Configure API permissions
This integration uses delegated permissions, which allow the app to act on
behalf of a signed-in user. For more information, see Overview of Microsoft Graph permissions
-
From your app registration, choose API permissions.
-
Choose Add a permission, then choose Microsoft Graph.
-
Choose Delegated permissions and add the permissions from the table below.
-
Choose Grant admin consent for [your tenant name] to approve the permissions.
Add the following as Delegated permissions in your Entra app registration.
For the full permissions reference, see Microsoft Graph permissions reference
| Permission | Description |
|---|---|
Files.ReadWrite |
Allows the app to read, create, update, and delete the signed-in user's files. |
User.Read.All |
Allows the app to read the full set of profile properties of all users in the organization on behalf of the signed-in user. |
offline_access |
Allows the app to refresh access tokens without requiring the user to sign in again. This reduces how often users need to re-authenticate. |
Record your credentials
Before leaving the Microsoft Entra admin center, confirm you have the following values. You need them for the Amazon Quick configuration.
| Value | Where to find it |
|---|---|
| Application (client) ID | App registration overview page |
| Directory (tenant) ID | App registration overview page |
| Client secret value | Certificates & secrets page |
Setting up the connector in Amazon Quick
Connect from the Available tab
If you want to use Default OAuth app authentication, you can connect directly from the Available tab without additional configuration.
-
In the Amazon Quick console, choose Connectors.
-
On the Available tab, find OneDrive and choose Connect.
-
Complete the Microsoft sign-in flow and grant the requested permissions.
To configure a connector with Custom OAuth app or Service-to-Service OAuth instead, use the Create for your team tab as described below.
Create from the Create for your team tab
After you complete any required Entra configuration, create the connector in Amazon Quick.
-
In the Amazon Quick console, choose Connectors.
-
Choose the Create for your team tab.
-
Find and choose Microsoft OneDrive.
Note
If a Microsoft OneDrive connector already exists, a dialog appears with your existing connectors. To use an existing connector, choose it. To create a new one, choose No, create new.
-
On the Integration type page, select Perform actions in Microsoft OneDrive and choose Next.
-
Enter a Name for your connector. Optionally, choose + Add Description to add a description.
-
For Connection type, choose Public network.
-
For OAuth Configuration, choose one of the following authentication methods and configure the required fields.
-
For Default OAuth app:
No additional credentials are needed. Choose Next to continue.
-
For Custom OAuth app (user authentication with delegated permissions), configure the following fields:
-
Base URL (Optional) – The Microsoft Graph API base URL. Example:
https://graph.microsoft.com/v1.0 -
Client ID – The Application (client) ID from your Entra app registration.
-
Client secret – The client secret value from your Entra app registration.
-
Token URL – The token endpoint. Example:
https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token -
Authorization URL – The authorization endpoint. Example:
https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/authorize -
Redirect URL – Pre-filled with the Amazon Quick callback URL.
-
-
For Service-to-Service OAuth (service authentication with application permissions), configure the following fields:
-
Base URL (Optional) – The Microsoft Graph API base URL. Example:
https://graph.microsoft.com/v1.0 -
Client ID – The Application (client) ID from your Entra app registration.
-
Client secret – The client secret value from your Entra app registration.
-
Token URL – The token endpoint. Example:
https://login.microsoftonline.com/{tenant-id}/oauth2/v2.0/token
Note
The scope for the client credentials token request (
https://graph.microsoft.com/.default) is set automatically by Amazon Quick. You do not need to configure it manually. -
-
-
Choose Next.
-
If you chose Default OAuth app or Custom OAuth app, a Microsoft authorization window opens. Review the requested permissions and choose Accept.
If you see an error instead of the consent dialog, your organization might restrict third-party app access. See Admin consent for Microsoft 365.
-
On the Review page, review the available actions for the connector. Choose Next.
-
On the Publish page, choose who can access the connector. You can enable access for everyone in your organization or search for specific teams or groups.
-
Choose Publish.
Available actions
After you set up the integration, the following actions are available.
| Category | Action | Description |
|---|---|---|
| Drive and items | Get Drive | Retrieve the properties and relationships of a drive. |
| Drive and items | List Item | Get all items contained in the drive. |
| Drive and items | Get Item | Get an item contained in the drive. |
| Drive and items | Create Folder | Create a new folder in the user's drive. |
| Drive and items | Update Item | Update the metadata for a file or folder. |
| Drive and items | Delete Item | Delete a file or folder. Moves the item to the recycle bin. |
| Drive and items | List Child Folders | Return a collection of items in the children of a folder. |
| Drive and items | Copy Item | Create a copy of a file or folder to another location. |
| Drive and items | Add Permissions | Send a sharing invitation for a file or folder. |
| Drive and items | Upload File | Upload a new file or update an existing file. Supports files up to 250 MB. |
| Excel workbooks | List Sheets | Retrieve a list of worksheet objects. |
| Excel workbooks | Add Sheet | Add a new worksheet to the workbook. |
| Excel workbooks | Read Sheet | Retrieve the properties of a worksheet object. |
| Excel workbooks | Update Sheet | Update the properties of a worksheet object. |
| Excel workbooks | Delete Sheet | Delete the worksheet from the workbook. |
| Excel workbooks | Read Cell | Get the value of a single cell by row and column number. |
| Excel workbooks | Write Cell | Set the value of a single cell by row and column number. |
| Excel workbooks | Read Range | Get the values of a range. |
| Excel workbooks | Write Range | Update the values of a range. |
| Excel workbooks | Clear Range | Clear range values, format, fill, and border. |
| Excel workbooks | Delete Range | Delete the cells associated with the range. |
| Excel workbooks | Get Used Range | Get the smallest range that encompasses cells with a value or formatting. |
Manage and troubleshoot
To edit, share, or delete your integration, see Managing existing integrations.
Authentication issues
-
Incorrect app registration – Verify the app registration in Microsoft Entra includes the required API permissions and that admin consent has been granted.
-
Expired client secret – Check if the client secret has expired in Certificates & secrets and generate a new one if needed.
-
Incorrect redirect URI – Verify the redirect URI in Microsoft Entra matches
https://.{region}.quicksight.aws.amazon.com/sn/oauthcallback
Common error messages
-
Access denied. You do not have permission to perform this action– The authenticated user does not have the required permissions. Contact your administrator to verify and grant appropriate permissions. -
AADSTS50020: User account from identity provider does not exist in tenant– The user account is not configured in the correct Microsoft Entra tenant. Verify the user account exists in the tenant that matches the Directory (tenant) ID in your app registration.
Admin consent for Microsoft 365
When you use the Default OAuth app authentication method, Amazon Quick uses an AWS-managed application to access Microsoft OneDrive on behalf of the signed-in user. Most users can complete setup without any extra steps. However, if your Microsoft 365 tenant restricts third-party app access, a Microsoft 365 administrator must grant one-time consent before users can connect.
If you see an error when you sign in during connector setup, your organization might restrict third-party app access. Share the following information with your Microsoft 365 administrator:
-
What to do: Grant admin consent for the Amazon Quick Microsoft OneDrive integration application.
-
Why: Amazon Quick needs delegated access to OneDrive files, folders, and Excel workbooks to perform actions on behalf of users.
An administrator can grant consent in one of the following ways:
-
Through the consent dialog – A Global Administrator or Privileged Role Administrator initiates the connector setup flow. In the Microsoft sign-in dialog, they select the Consent on behalf of your organization check box and choose Accept.
-
Through the Microsoft Entra admin center – Sign in to the Microsoft Entra admin center
on the Microsoft website. Choose Enterprise applications, locate the Amazon Quick application, choose Permissions, and choose Grant admin consent for Your Organization.
After consent is granted, any user in your organization can connect without being prompted for individual consent.
Note
To check whether your tenant restricts user consent, go to the Microsoft Entra admin center and choose Enterprise applications, Consent and permissions, User consent settings. If the setting is Do not allow user consent, an administrator must grant consent before users can use the connector.
