cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akharns
Helper V
Helper V

Record Not Found in Excel Get Row

I am using Excel Get Row.  I have correctly identified the Excel table, the key column, and the value.  The table does have rows with that value in that column, but Get Row is returning 404:

{
"status": 404,
"message": "No row was found with Id ''2019-10''.\r\nclientRequestId: ab52f302-21c3-4a77-b944-97b3164c8044\r\nserviceRequestId: a7020a36-5eb6-400a-a139-e2d5f8271e43",
"source": "excelonline-cus.azconn-cus.p.azurewebsites.net"
}
1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @akharns 

 

Map the Key value from a compose output step. It could be the type which you mapping is not quite right. I have experienced this in the past for another flow step. Declare a compose step above Get Row. Map the field. Then inside the Get Row map the compose output.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
Super User
Super User

Hi @akharns 

 

Map the Key value from a compose output step. It could be the type which you mapping is not quite right. I have experienced this in the past for another flow step. Declare a compose step above Get Row. Map the field. Then inside the Get Row map the compose output.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

I was sending a literal value, and I had quotes around it.  Taking them off worked.  Thanks.

I was having the exact same problem with 'Update a row' and 'Get a row' connector on an Excel table. In case it helps someone else, I have solved it by ensuring table headers were all declared as 'Text' in Excel (had columns named '1', '2', etc). Also, it seems the Key needs to be 'Text' as well.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,128)