Authorization

When you add an Excel Online card to a flow for the first time, Okta prompts you to configure the connection. This helps you to connect your Excel Online account, save your account information, and reuse the connection for future Excel Online flows.

Create a connection using an Excel Online admin account or an Excel Online user account. Okta recommends that you use an Excel Online admin account when creating a connection for the first time.

• Create a connection with an Excel Online admin account

• Create a connection with an Excel Online user account

• Prohibit users from creating connections

• Reauthorize a connection

Office 365 GCC High tenants

Okta Workflows in Okta for Government High only supports connections using accounts from Office 365 GCC High tenants.

Create a connection with an Excel Online admin account

1. Click New Connection.

2. Enter a Connection Nickname. This is useful if you plan to create multiple Excel Online connections to share with your team.

3. Click Create.

4. Log in to your Excel Online account to authorize the connection.

5. Select one of the following options:

   1. As an admin you don't want regular users to create connections. Click Accept and make sure that the Consent on behalf of your organization option isn't selected.

   2. As an admin you want regular users also able to create connections. Click Accept and make sure that the Consent on behalf of your organization option is selected. All user accounts in your organization can create connections on their own.

Create a connection with an Excel Online user account

1. Click New Connection.

2. Enter a Connection Nickname. This is useful if you plan to create multiple Excel Online connections to share with your team.

3. Click Create.

4. Log in to your Excel Online account to authorize the connection.

5. Select one of the following options:

   1. Can accept the permissions requested directly.By selecting this option, the admin allows regular user consent for this Okta app.

   2. Need admin approval. Contact your admin to grant you access to the application. See Consent for all apps or Grant tenant-wide admin consent

   3. Need to submit an approval request. Enter a justification for requesting this app in the space provided. See Enable the admin consent workflow.

6. Click Accept.

Admin app approval

Admins can grant Okta app access to regular user accounts. If an admin forgets to select the Consent on behalf of your organization option and then clicks Accept when configuring a connection, the authorization page might not appear using the same admin account. This occurs because the Okta app authorized the connection and is remembered by the system.

The following information provides other ways for an admin to grant Okta app access to regular user accounts.

Consent for all apps

Allow user consent for all apps, or for apps from verified publishers, for selected permissions. Configure permissions as Global Admin only. See Configure how users consent to applications.

1. In the Azure Portal, select Azure Active DirectoryEnterprise applicationsConsent and permissionsUser consent settings.

2. Select one of the following permissions options:

   • Allow user consent for apps. This is a less secure option.

   • Allow user consent for apps from verified publishers. This is a secure option. Configure the following permissions as low impact:

     • Files.ReadWrite

     • offline_access

3. From Enterprise applications go to the Admin consent requests page and review and grant access.

Grant tenant-wide admin consent

You can grant tenant-wide admin consent for an Okta app only if your admin account, or any other admin accounts, has authorized the Okta app. See Grant tenant-wide admin consent to an application.

1. In your Azure Portal, go to Azure Active DirectoryEnterprise applications.

2. Select one of the following Okta apps:

   • Excel Online for Okta Workflows

   • Excel Online for Okta Preview

3. Select PermissionsGrant admin consent.

   All regular user accounts in your organization have been granted consent to the Okta app.

Enable the admin consent workflow

Enable regular users to request access to applications that require admin consent. Users can't directly create connections until an admin approves the request. Configure permissions as Global Admin only. See Configure the admin consent workflow.

1. In your Azure Portal, select Azure Active DirectoryEnterprise applications.

2. Under Manage, select User settings.

3. Under Admin consent requestsUsers can request admin consent to apps they are unable to consent to, select Yes. See Configure the admin consent workflow.

4. From Enterprise applications go to the Admin consent requests page and review and grant access.

Prohibit users from creating connections

Remove admin consent that was granted previously by deleting the Okta app in Enterprise applications and then reauthorize it. If you delete the app that revokes the admin consent tenant-wide. Revoking individual user consent isn't allowed.

All existing connections stop working after one hour. For previously configured admin connections that you want to keep active, manually reauthorize them and use the consent process to avoid connection failure.

1. In your Azure Portal, select Azure Active DirectoryEnterprise applications.

2. Select one of the following Okta apps:

   • Excel Online for Okta Workflows

   • Excel Online for Okta Preview

3. Select Delete.

Admin consents previously granted are revoked and regular users can't create connections until admin consent is granted.

Reauthorize a connection

If you've used your account to create a connection successfully, you can use this account to create multiple connections. If you've already created connections you can reauthorize these connections as long as there are no configuration changes made by the admin.

Related topics

Excel Online connector

Workflow elements

Guidance for Excel Online connector

Excel Online API documentation