cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

Highlighted
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
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: 104 members 5,256 guests
Please welcome our newest community members: