Hi Team,
I have got a requirement to store the Excel data as Sharepoint list (and then all add/delete/update operation should be synced), I can achieve that part. But the challenge I am having is:
Excel is having some legal data so business has kept this file as password protected. So table design option is coming as greyed out, and "table 1" name is appearing as greyed out.
So when I store that file to my One drive and add that file in my flow, then under table option following error message is appearing:
The dynamic invocation request failed with error: { "status": 400, "message": "Graph API encountered unsupported features in the workbook and was unable to work with it. Please remove the unsupported content and try again.\r\nclientRequestId: c06f9a28-4e42-4f33-b13d-1ac2-95a3113b\r\nserviceRequestId: 15789766-cede-42fd-abf1-d21a15782e63", "error": { "message": "Graph API encountered unsupported features in the workbook and was unable to work with it. Please remove the unsupported content and try again." }, "source": "excelonline-ncus.azconn-ncus.p.azurewebsites.net" }.
Any suggestion how to achieve this.
And even if I make it unprotected once and add that to flow, and then re-protect the file again, will flow work?
Any suggestions!

Report
All responses (
Answers (