web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Delete a row in Excel ...

Power Automate

Answered

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

(0) Share

Report

Report

Posted on by J0el

58

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

eric-cheng 5,171 on at

Like (1)

Report

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

Was this reply helpful? Yes No
J0el 58 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation