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.

 

 

View solution in original post

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.

 

 

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

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 Solution Authors
Top Kudoed Authors
Users online (5,351)