Delete a row in Excel - No row was found with Id ##

[J0el]

Hi there,

I have a flow that I believe should work. I have trawled the Internet, but am coming up short.

Here is my flow:

The Compose input is: 

array(items('Apply_to_each')?['ID'])

Here is the output I'm getting:

Error:

I have tried changing the Compose input to convert to int, which does convert but brings the same error:

array(int(items('Apply_to_each')?['ID']))​

Here is the Table in Excel with the ID column. I have tried other unique columns too:

Cheers,

Joel

[eric-cheng · Accepted solution]

Hi @J0el ,

Try the below.

Expression for ID in Delete a row is:

@item()?['ID']

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[J0el]

Thank you Eric! I was starting to lose faith! 😁😁

For anyone else who has a similar issue, I had to remove the '@' from the beginning of your expression to make it work.