Unanswered

Flow failing to interact with Excel(business)

(1) Share

Report

Posted on by 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:

api error.png

Thanks!!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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-5af9df0ac664

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.

Was this reply helpful? Yes No
SuporteCCAB 5 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Nathan3 11 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nathan3 11 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
tjr6ca 3 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No