Forum Discussion
How can I automatically delete data connections in Excel ONLINE (Sharepoint)?
I have created an Excel workbook in Sharepoint with PivotTables with a PowerBI connection (a Lakehouse in Fabric). Since the data itself gets updated monthly, I'd like a copy of the Excel without the...
Could you please clarify how this option
"Send an HTTP request to SharePoint" action to update the metadata of the copied file, which could include removing the data connections.
exactly works
You're correct, and I apologize for the confusion. Directly modifying the content of an Excel file, such as removing data connections, isn't feasible through Power Automate or SharePoint's REST API alone.