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

(0) Share

Report

Posted on by Skobu

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": ""
},

Categories:

Building flows

I have the same question (0)

All responses (1)

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