Record Not Found in Excel Get Row

[akharns]

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"

}

[abm · Accepted solution]

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.

[akharns]

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

[mariamingallon]

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.