Edit in Excel option for On Premise Business central

 

Register and configure an application in Microsoft Azure to connect Excel

Sign to Azure Portal

App registrations- New Registrations

Highlighted checkmark parameters values change as per below in Manifest

In the editor, set "oauth2AllowIdTokenImplicitFlow" and "oauth2AllowImplicitFlow" keys to true:

 

"oauth2AllowIdTokenImplicitFlow": true,

"oauth2AllowImplicitFlow": true,

 

In the "replyUrlsWithType":[] key, add the following lines:

 

{

    "url": "https://az689774.vo.msecnd.net/dynamicsofficeapp/v1.3.0.0/*",

    "type": "Spa"

}

Grant the Excel add-in application permission to access the Business Central application Web API.

Give the Microsoft Entra application for the Excel add-in delegated permission to access the Business Central application Web API, which you exposed earlier in this article. This permission allows users of the Excel add-in to access the OData web services to read and write data.

 

o   From the application's Overview page, select API Permissions.

o   Select the Add a permission

On the APIs my organization uses, select the Business Central application ( if you have your own application then select, if not then create new application)

o   Select Delegated permission.

o   Search for Business Central API by using registered application's name or application ID.

o   Select the permission from the list, then select Add Permission.

7.              On the application's Overview page, copy the Application (Client) ID that is assigned to Excel add-in application.

You'll need it to configure the Business Central Server instance

 

$serverInstance = 'Production'

Set-NAVServerConfiguration -ServerInstance $serverInstance  -KeyName AppIdUri -KeyValue api://475d045a-4e00-4axxb-86b-9fb182c7698

 

Note:- This is ApplicationIDURi for the application which you have linked in the API permissions.

 

Set-NAVServerConfiguration -ServerInstance $serverInstance -KeyName ExcelAddInAzureActiveDirectoryClientId -KeyValue b98cbd54-b1ae-4589-9xxx-8bc09d4ad46c

 

Note:- This key value in Excel addin App registration Client id.

 

Set-NAVServerConfiguration -ServerInstance $serverInstance -KeyName PublicWebBaseUrl -KeyValue https://bc.nt.com.sg/Production

 

Note- This is your BC web link address

 

Set-NAVServerConfiguration -ServerInstance $serverInstance -KeyName

PublicODataBaseUrl -KeyValue https://bc.nt.com.sg:5048/Production

 

Note- Odatabase URL

 

Set-NAVServerConfiguration -ServerInstance $serverInstance -KeyName ApiServicesEnabled -KeyValue true

 

amend manual values as highlighted in black color in Valid Audiences

9487323b-05f-49eb-bb4a-899f4dd8a;api://475dxx5a-4e00-4b-856b-9fb182c7xxxdb;https://api.businesscentral.dynamics.com