News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Delete a row - Excel O...

Power Automate - Building Flows

Answered

Delete a row - Excel Online (Business)

(0) Share

Report

Report

Posted on by Jason79

41

Hi Forum

Flow is triggered when a file is created in OneDrive folder. Create table in range A1:H28 and add table headers.

Hour

Day7

Day6

Day5

Day4

Day3

Day2

Day1

In Hour column there are 3 rows that I want to delete

Row 2 contains text - Strategic........

Row 3 contain text - Payment.......

Row 4 is blank - ""

The output of List rows present in table includes below

"Hour": "Strategic"

"Hour": "Payment

"Hour": "",

I have added a Apply to each

Select an output from previous steps as below

Error Detail: No row was found with Id 'Strategic'.

Any advice / solutions to delete the 3 rows mentions above would be really appreciated.

Thanks

All responses Img

All responses (5)

Answers Img

Answers (1)

Verified answer

Nived_Nambiar 17,895 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete a row - Excel Online (Business)

Hi @Jason79

I got the reason behind the above error

see the Hour column value for strategic

The value you have passed in delete row action for Hour is Strategic ,

But it should be Strategic option instead 🙂

Hope it helps !

Mark it as solution if it resolves your query !
Jason79 41 on at

Like (0)

Report

Re: Delete a row - Excel Online (Business)

@Nived_Nambiar
When I add a compose Value attached is the output example

compose_output.docx
Nived_Nambiar 17,895 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete a row - Excel Online (Business)

Hi @Jason79

before using apply to each, use compose action and then enter the value dynamic content, run the flow, and show the results coming under compose action 🙂
Jason79 41 on at

Like (0)

Report

Re: Delete a row - Excel Online (Business)

Hi @Nived_Nambiar

Not sure what you're asking for but is it below?
When I hover over value in Apply to each
Outputs('List_rows_present_in_a_table')?['body/Id']
Nived_Nambiar 17,895 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete a row - Excel Online (Business)

Hi @Jason79

Could you show how values dynamic content looks like ?

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans