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