cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Excel problem

Dear members, 

 Please kindly help to solve the following problem: (see the following error message when trying to create a flow involving an Excel file)

 

Error al ejecutar la API "/codeless/v1.0/drives/b!fFYYrV9Js0Ge6aCxEwmAXLk-jagVAqlPkBFLkR5gcf5-yG3-nGALRJwWMwn3E6A8/items/01R2WKDTYOCTTNM2OJRFEKR577JBTPNJ6Z/workbook/tables/%7B024FF4A5-2F57-49D4-A96A-3CA571D2B873%7D/metadata"

 

Best regards,

Pedro

 

9 REPLIES 9
Super User
Super User

Re: Excel problem

Hi @Anonymous 

 

Can you please share a screenshot of the flow and a screenshot of the error? Having a look at that will give us a better idea of what the error might be and we will be able to better assist you that way. 

 

I am guessing this error is popping because the excel connector is unable to find an element. But need to see th screenshot to be sure. 

 

Can you confirm that, in the excel action, you are using the folder icon to select the excel file and dropdowns to select the table/ worksheet and not manually entring any custom values in those ? (this might be a cause of the error too)!

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Re: Excel problem

Captura.PNG

Dear Super User,

 

First of all, thank you for your prompt answer.

Thing is that I am trying to build a flow using Excel (for business) [as you can see in screenshot above]. The problem is that once the file is selected (from the dropdown menu), microsoft flow is unable to identify the tables that have been named in the excel file. The field table is automatically filled with a table reference that is in Hexadecimal code (find picture2 below)Captura2.PNG

Truth is that before I used to work with a different version of the file and for some reason I had to create a copy with a different name (version (3) for instance). I was having issues updating the fields in the new Excel sheet and removed the two previous versions and linked flows to the (3)_new version.I am wondering if there is a constraint to access the excel file that is not allowing flow to access to the inner data of the excel file...could it be the issue?

I would appreciate any of your insights and potential ways of solving this issue. 

Thank you in advance.

Best,

 

Pedro

Super User
Super User

Re: Excel problem

Hi @Anonymous 

 

Can you delete this action,  save the flow and refresh and create a new action (the same one?). Can you check in the xcel sheet what is the name of the table?

 

The refresh should help as it might take flow to the cached file and not update the table name. 

 

Hope this Helps!

Anonymous
Not applicable

Re: Excel problem

Hi again Super User,

 

Checked the excel file and all the tables have their name assigned. Microsoft Flow should be able to recognize the name of the tables as it did with the previous versions...

Tried to create a new flow from scratch and got the same issue:

Captura3.PNG

According to Flow, the file doesn't contain any table with name...the file, however, does include names for all the tables (see one of the examples below):

Captura4.PNG

Despite all the tables are named, no one is recognized in the Moicrosoft Flow platform...all the former versions of this file shared the same names for the tables and never ran into a similar issue.

The Table is stored in the specified folder since Microsoft Flow is able to find the Excel file but doesn't seem able to access the information it has on it....

Thank you again for your support...

Best,

 

 

Pedro

Super User
Super User

Re: Excel problem

HI @Anonymous 

 

Did you try deleting the current connection to excel and create a new one? Also, can you please create a new excel in your one drive and create a table in it and check if you are able to access that?

Anonymous
Not applicable

Re: Excel problem

Hi Super User,

 

Already tried this.

Could it be a technical issue? Programming related?

 

Thank you in advance.

Best,

 

Pedro

Anonymous
Not applicable

Re: Excel problem

Hi Super User,

 

I just realized that the Excel file I am working with is full of formulas between the columns...could it be a reason for the malfunction of the Microsoft Flow's table recognition? Could it be that Flow can only work with a limited amount of formulas?

I copied the values of the table to a new file (removing all the formulas) and flow recognized the table as such.

Is it a software limitation? 

I do really need to have the table with all the formulas set since the file autoupdates itself with the information received from the emails.

Thank you in advance.

Best,

 

 

Pedro

Super User
Super User

Re: Excel problem

Hi @Anonymous 

 

That might be a limitation on the connector. You can find more details on the excel connector with one drive here: 

https://docs.microsoft.com/en-us/connectors/excelonline/

 

There are certain limitations on the files/tables/rows access etc. So that might be a reason why the table is not popping up. 

 

Hope this Helps!

Community Support Team
Community Support Team

Re: Excel problem

Hi @Anonymous ,

 

What are the functions in the Excel table?

 

Are there any special formats in the file?

 

I have an Excel table which contains functions, sub and mul, however, the table name could be selected from Flow without any issue.

1.PNG2.PNG

 

 

Best regards,

Mabel

 

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

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 429 members 5,393 guests
Please welcome our newest community members: