cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jmenas
Level: Powered On

ERROR Get tables Excel - Error 400

Hi All,

 

I am trying to build a Flow to get an Email attachment Unzip it and then add then getting the rows from the XLS file to a new XLSX file. When I create the flow I just can get rid of the error 400 in the Get Tables.

Any idea why? the XLs doesn't have any predefined Tables, but I can assign them one automatically with MSFlow, right? 

Here is the error:

 "status": 400,
  "message": "Failed to read metadata from file source. Response from the end service is : Bad Request\r\nclientRequestId: 96b1c7a8-13ba-43d7-9c49-0d136a342304\r\nserviceRequestId: 96b1c7a8-13ba-43d7-9c49-0d136a342304;96b1c7a8-13ba-43d7-9c49-0d136a342304",
  "source": "excel-ne.azconn-ne.p.azurewebsites.net"

This is when the flow is failing:

 

 

2018-10-26 16_27_04-h2xwlw5o75so3tfn.myfritz.net_2002 - Remote Desktop Connection.png

5 REPLIES 5
Community Support Team
Community Support Team

Re: ERROR Get tables Excel - Error 400

Hi @Jmenas,

 

Could you share the full screenshots of your Flow configuration?

It seems that the Get tables action configuration does not meet the requirements.

I am not sure what "getting the rows from the XLS file to a new XLSX file" means.

Is all the rows from the excel file in the attachment, and then inserted into the table of the new excel file? Or something else?

Could you provide more explanations about this, which helps to understand and build a Flow that can fulfill such needs.

Please provide more details and we would provide proper workaround for you.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jmenas
Level: Powered On

Re: ERROR Get tables Excel - Error 400

Hi @v-bacao-msft,

 

Here are the Flow details that you mentioned: 

About the XLS and XLSX, these are the file extensions. The point of the excel is to create a workaround the issue with the .xls format. I need to add the rows to a .xlsx master file so it can be consumed in PBI Service. If you know a better way let me know. 

 

Here are the screenshots of the complete flow:

Part1.pngPart2.png

Super User
Super User

Re: ERROR Get tables Excel - Error 400

You can't do a get tables if you haven't got tables defines. You will have to use the create table first.
Jmenas
Level: Powered On

Re: ERROR Get tables Excel - Error 400

@Pieter_Veenstra
Thanks I tried to create the table but I get this error when I create it: 
                 2018-11-05 15_41_23-Flow.png 

Message:

"status"400,
"Der Ausdruck \"drives('01XXXXXXXXXXXXXXXXXQ')/items/fileXY.1111.xls\" ist ungültig.\r\nclientRequestId: 4d56e04a-e66b-XXXXXXXX-Xxxx-xxxx"
,

 

Any Idea why? I tried to define the correct path in the OneDrive directory (dynamically) but I always get the error. I think the document library is wrongly defined. but What it is exactly the Flow doc is not so clear. 

Best,
J.

Super User
Super User

Re: ERROR Get tables Excel - Error 400

Can you try to set a range of A1:J20 as a test?

Could it be that a different table already exists in the sam location?

Can you try it with a clean new spreadsheet?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 175 members 4,636 guests
Please welcome our newest community members: