"Excel Online (Business)" connector always requires write permissions ?

Like (0) Share

Report

Posted on 12 Mar 2025 09:46:20 by DD-12030943-0

Hello everyone,

I've been tasked to create a Powerautomate flow to do some automation with excel files in sharepoint.
I've been granted read access to the necessary files, and I just need basic actions such as "Get tables" and "Get worksheets".

However, when I run my flow, I get the error : "The user doesn't have permissions to open the workbook in edit mode".

Are write permissions really mandatory to use this connector ?

What kind of work around could I use ?

Thanks in advance for your answers

All responses (2)

Answers (1)

Verified answer

DD-12030943-0 23 on 02 Apr 2025 at 06:41:53

Like (0)

Report

"Excel Online (Business)" connector always requires write permissions ?

From what I could gather, write permissions are mandatory, even If you only want to read data.
Building with Why 261 on 12 Mar 2025 at 13:51:28

Like (0)

Report

"Excel Online (Business)" connector always requires write permissions ?

If you need to edit the table, yes you need write permissions to the file.

If you can't be given write permissions an alternative is to create a service account which can write to the account from Power Automate.

If this post helped, please like and mark as answered.