Permissions for Excel Actions

To use the Excel actions to retrieve the worksheets and enable the Workflow Studio to read/update/add/delete records in a table within the worksheet, the following permissions are required in the Application Registration in the Azure portal. The Excel actions are as follows:

Excel get table rows
Excel add, update or delete table rows

Delegated Permission (OAuth2 Authorization Code)

Table 1. Delegated Permission
Name	Type
Files.ReadWrite.All	Delegate
User.ReadBasic.All	Delegate
User.Read	Delegate

Application Permission (OAuth2 Client Credentials)

This permission is not available as it would be a security concern to have Excel worksheet access for all users in an organization.

Scope

The following scope must be configured inside the Connection under Scopes.

openid email profile offline_access Files.ReadWrite.All

↑