web

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

Power Platform CommunityForums Power Automate - Building Flows How to delete the firs...

Power Automate - Building Flows

Unanswered

How to delete the first row of a table that is empty?

(0) Share

Report

Report

Posted on by Skobu

14

Hi, currently I am trying to delete all rows of an excel file table. Everything goes right except the first one that is completly empty.

Is empty because I am using a excel as template and when I create the table it automatically creates the first row without values. Then I pass the new rows but it starts only on the second one.

Any way of deleting the first row even if is empty?

{
"@odata.etag": "",
"ItemInternalId": "5d34eb2f-2024-47a9-8f78-626af47990a6",
"Order": "",
"CO Object Name": "",
"Cost Element": "",
"Cost element name": ""
},

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Re: How to delete the first row of a table that is empty?

Hi @Skobu ,

If you want to delete the blank line in the first line, please try this flow.

I did a test for your reference.

In my scenario:

@And(equals(item()?['Order'], ''),equals(item()?['CO Object Name'], ''),equals(item()?['Cost Element'], ''),equals(item()?['Cost element name'], '')) items('Apply_to_each')?['Order']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans