When the client secret expires it must update everywhere to ensure uninterrupted access to your data.
Important
A Client Secret in Microsoft Entra ID can only be set for a maximum validity of 2 years. Planning ahead avoids service interruptions.
Prerequisite
Step 1: Update in MAUI SharePoint Online Sites
For detailed instructions please refer to: Adding your Microsoft Entra ID app registration to settings in MAUI
Go to your MAUI SharePoint Online Site.
Go to Settings.
In Settings go to Data Source Configuration.
Select the Authentication Settings for your SharePoint Online connection.
Replace the old Client Secret with the new one.
In MAUI select Save.
Step 2: Update in Templates
Depending on your configuration, the client secret may be stored in:
Option 1: The Excel Connection File
Option 2: The Template
Option 1: Excel Connection File
For detailed instructions please refer to: Using a Microsoft Excel config file for the Add-In’s Microsoft Entra ID configuration
Select the Excel config file used by your templates.
Go to the section where the Client Secret is stored.
Replace the old secret with the new one.
Inside the file menue select Save.
Test the connection.
Option 2: Inside the Template
For detailed instructions please refer to: Connecting a SharePoint Data Source
Select the template.
Go to the Data Map > Data Sources > SharePoint Data Source > Office 365 Entra ID.
Inside the Entra ID Configuration window replace the Client Secret.
Select OK > select OK > in the Datamap select Save.
Test the connection.
Important
If Power Automate or other integrations are used, update the Client Secret there also.
Result
All data source connections are successfully updated with a new Client Secret, ensuring uninterrupted access.