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

Getting a row from Excel Online (Business) giving error 404

Hi,

I have a Flow which has to get a value in an Excel online Table.

The key row contains the displayname of a user and I use "created by Dyplayname" as Key, as I want to get a value for the user that created the list entry.

The flow returns an error on this point with Error status 404, message "No line found with ID "XXX" "...

Any idea? Sorry if it's unclear ;-)

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Level 10

Re: Getting a row from Excel Online (Business) giving error 404

Hi @dgoguet ,

I have made a test on my side, it has the same issue with you when add a new column to the table.

I will raise this issue to MS Team,  I think it will be fixed in the future.

 

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

5 REPLIES 5
v-zhos-msft
Level 10

Re: Getting a row from Excel Online (Business) giving error 404

Hi @dgoguet ,

Could you please share a screenshot of your flow's configuration? 

Could you please share more details of your excel file?

I have made a test on my side, please take a try with the following workaround:

Please make sure you have selected the correct Key Column and Key value.

1.png2.png

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dgoguet
Level: Powered On

Re: Getting a row from Excel Online (Business) giving error 404

Thanks for your answer,

In fact, I tried with a very simple flow, manual execution then Excel get row action. Yes, I am using the correct Key Column and Key Value.

I just ran into a simple fact:

The flow works until I add formulas in some of my Table Columns... As soon as I add a formula in a column (even a really simple one), I get a 404 error... Is there a know problem at this point?

Thanks again

v-zhos-msft
Level 10

Re: Getting a row from Excel Online (Business) giving error 404

Hi @dgoguet ,

Could you please share a screenshot of your flow's configuration?

Could you please share more details of your excel file?

Then I can do more test for you.

Best Regards,

Zhongys

dgoguet
Level: Powered On

Re: Getting a row from Excel Online (Business) giving error 404

Hi,

My flow is very simple:

flow.png

My Excel file as well:

excel1.png

 

If I run the flow on this simple table, it succeeds:

 

result 1.png

 

But when I add columns to my Excel Table, the error seems to be random. In the example below, I could add the "Cumul" column and run the flow successfully, but when I added column "1", it failed:

Excel2.png

result2.png

This is quite strange as the behaviour seems random... Sometimes It fails when I add one column, sometimes I can add 3 columns before failure... and sometimes it runs the first time but it fails if I run it a second time, even without adding a column... 

The Excel file is located on a sharepoint library.

Thanks for your help!

v-zhos-msft
Level 10

Re: Getting a row from Excel Online (Business) giving error 404

Hi @dgoguet ,

I have made a test on my side, it has the same issue with you when add a new column to the table.

I will raise this issue to MS Team,  I think it will be fixed in the future.

 

Best Regards,

Community Support Team _ Zhongys

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

Join us 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: 213 members 4,997 guests
Please welcome our newest community members: