cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

excel getrows on created

I'm having a problem with GetRows from Excel with Flow not liking my Table name on a created file in OneDrive.

 

Using the same file when modified - so hardcoded and Table name picked from drop down works fine::

When created

 

https://1drv.ms/i/s!AkPnQ5ezT9ZEp6ZuL0EL_ZjSKzsT7g

 

{ "status": 400, "message": "Failed to read metadata from file source. Response from the end service is : ObjectHandle is Invalid", "source": "127.0.0.1" }

 

On modified

 

Modified

https://1drv.ms/i/s!AkPnQ5ezT9ZEp6ZtOZkIET_AGoL-YA

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Automate
Power Automate

Re: excel getrows on created

Hi Ed,

 

Please try passing "File identifier" instead of File name from dynamic content

 

OneDrive_GetRows.png

 

 

Thanks

Chandra

View solution in original post

10 REPLIES 10
Highlighted
Community Support
Community Support

Re: excel getrows on created

Hi EdR,

 

Did you mean that when the field is filled with "OneDrive-File Name", flow runs successfully, but when fileld is "/Orders/S1b.xlsx", then it will fail?

 

If this is the situation, I created a table with the same name in my OneDrive, both flows run successfully. I'm unable to reproduce your issue.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: excel getrows on created

the other way around Mona - with a hardcoded filename it works. When I use the filename from the input - as would be the reality as the filename can;t be predicted - but testing with dropping in the very same file - it fails with this error.

 

Ed

Highlighted
Regular Visitor

Re: excel getrows on created

Outputs
  • Headers
    { "Pragma": "no-cache", "x-ms-request-id": "e02d7ee3-3425-4b71-a765-4b6a237bfd10", "Cache-Control": "no-cache", "Date": "Wed, 25 Jan 2017 05:34:18 GMT", "Set-Cookie": "ARRAffinity=7ab1fec59f611f278bc539caf223232cbf4a073f87e005294db91b5921ad6504;Path=/;Domain=127.0.0.1", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "148", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }

Body

{ "status": 400, "message": "Failed to read metadata from file source. Response from the end service is : ObjectHandle is Invalid", "source": "127.0.0.1" }
 
Happens on both Create or modified when the filename is 'dynamic' but using the VERY SAME file and specifying the name hardcoded - it works
Highlighted
Power Automate
Power Automate

Re: excel getrows on created

Hi Ed,

 

Please try passing "File identifier" instead of File name from dynamic content

 

OneDrive_GetRows.png

 

 

Thanks

Chandra

View solution in original post

Highlighted
Regular Visitor

Re: excel getrows on created

Thank you Chandra that works for me. Could you explain why?

 

Regards,

Ed

Highlighted
Power Automate
Power Automate

Re: excel getrows on created

This has to do with internal Id used by the connector to look up the file in OneDrive.
When you select a file using connector wizard it has a mapping of the internal Id for the selected file. Passing FileName from dynamic content fails because it has no mapping of the internal Id for the file.

 

Thanks

Chandra

Highlighted
Frequent Visitor

Re: excel getrows on created

Hi, I am experiencing the same issue. I've switched to selecting 'file identifier' from the dynamic content, but the error remains.

 

The only difference with my set up is that the Excel SS is in a SharePoint Library, is this likely to cause the error?

 

Thanks in advance

 

Chris

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: excel getrows on created

I have the same challenge.

 

I work with a combination of an excel file as the "database" ("DB" - file stays the same file under normal conditions, unless there is a OneDrive Sync issue) and 2 input files ("01", '02"), which are named differently by a macro each time with a different file name.

 

Result is either:

when using fixed file and table references, I struggle with bad request as decribed above 

or

when I use dynamic file and table references or I can retrieve the table columns for further actions, yet get failure when the file changesI can retrieve the table columns for further actions, yet get failure when the file changesI get no columns, when using variablesI get no columns, when using variablesvariables, I struggle with  

- empty input array 

  or

- issues with column references when transfering data from input file (01,02) to the data base file (DB).

Highlighted
Frequent Visitor

Re: excel getrows on created

@ErichH  Hello - did you ever find a resolution to this issue? I am facing a similar challenge with the 'Insert Row' action. 

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: excel getrows on created

In the end I moved my dB file to a SharePoint list. 

That works just fine. 

 

So solved the issue by moving away from excel approach.

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,092)