News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Delete a row in Excel ...

Power Automate - Using Flows

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

All responses Img

All responses (2)

Answers Img

Answers (1)

J0el 58 on at

Like (0)

Report

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

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.
Verified answer

eric-cheng 5,171 on at

Like (1)

Report

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

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,651 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans