To allow Power Automate to update the connections automatically, I created a Script in the Excel file which simply updates all connections in the workbook. Here is the script that I use:
Office JS error: Line 2: Workbook refreshAllDataConnections: There was an internal error while processing the request.
clientRequestId: f2c84415-32a9-40e8-b129-403af56b4b27


Report
All responses (
Answers (