Flow failing to interact with Excel(business)

[SuporteCCAB]

Hello!

I'm having trouble using the excel(business) tools in Flow.

I just cannot get any of the connectors to work, if I try to 'insert a row' the connector cannot find any tables in the .xlsx file, if I try to create a table in a spreadsheet, I get an error from flow, (401).
I've tried switching sites and libraries, file names, etc. I can open the files in browser just fine, they are not open in any device when I'm trying to configure the flow or when the flow is running.


Error 1 - Trying to create a Table in a .xlsx file:

Error 2 - Trying to locate a Table in a xlsx File:

Thanks!!

[v-alzhan-msft]

Hi @SuporteCCAB ,

The Create table action run failed because you don't have the permissions to open the file in the browser,please check you permission for the file.

The Add a row into a table action run failed for couldn't retrieve the values, have you created a table in the excel file before? If not, please refer to link below to create a table in the excel file:

https://support.office.com/en-us/article/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac6...

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SuporteCCAB]

Hi Alice!

Yes I have total access to the file, and I've created a table in the file that I was trying to "insert a row".
One thing that I failed to mention, is, we have local based access policy, but everything works fine, I don't think this is the problem.

Thanks!

[Nathan3]

@SuporteCCAB @v-alzhan-msft I'm having this same issue.  Were you able to figure out a solution?

[Jcook]

Hi,

Can you check which connection is being used for the Excel connector.

You should see a email on bottom of action. Click that and select a new connection. Or create a new one.

Make sure the connection you are using has permissions on that file.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

[Nathan3]

Hello,

It looks to be using the appropriate connections.  I confirmed my email is at the bottom of the action but created a new connection just in case.  I have verified that I have permissions on the file but am still getting the same error.

Nathan

[tjr6ca]

I am having this exact same issue. I don't have permissions to use regular excel because i'm not an admin, and Excel for business doesn't work. It's like there are two connectors. Do i need to ask for admin access or license for Excel non-business version