web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Not able to create Tab...
Power Automate
Unanswered

Not able to create Table out of Protected Excel file for MS Automate

(0) ShareShare
ReportReport
Posted on by 2

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:

 

rsinha_0-1637149298829.png

 

 

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!

Categories:
  • rsinha Profile Picture
    2 on at

    Hi Folks,

    Any suggestions??

    The excel file is having 8-10 worksheets, and having large data, could that be the reason that flow is not able to read that?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard