I am trying to take an excel file and create tables within it so I can push it up to a sharepoint list, but it has a series of toolbar and activeX controls. I would usually just create an editable copy offline but I am trying to have everything automated. Is there any way to remove these controls via power automate?
Here is the error message I get when I try get worksheets from the file
{
"status": 403,
"message": "The request is forbidden by Graph API. Error code is 'UnsupportedFeatureEditWarning'. Error message is 'This workbook cannot be edited because it contains the following features:\r\n\r\n• Objects like form toolbar controls, toolbox controls, and ActiveX controls\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.'.\r\nclientRequestId: 59af48ec-d1be-48a1-bb7f-349a2adb7a80\r\nserviceRequestId: 8c1a2e15-6978-4e36-a0b8-1081d4925fc2",
"error": {
"message": "The request is forbidden by Graph API. Error code is 'UnsupportedFeatureEditWarning'. Error message is 'This workbook cannot be edited because it contains the following features:\r\n\r\n• Objects like form toolbar controls, toolbox controls, and ActiveX controls\r\n\r\nTo edit this workbook, open the workbook for viewing, select Save a Copy from the File tab, and edit the new copy.'."
},
"source": "excelonline-cus.azconn-cus.p.azurewebsites.net"
