Creating Excel Table, Table Range Formula, need to skip first row!

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

I currently use create table in power automate. It works fine when I have my excel file with headeres in row 1.

But what if they start in row 2?

I currently use this table range formula - =offset(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),29)

Which creates a table for me. But I need to skip the first row as my excel coming in now has a placeholder text in the first row which does not contain headers.

any help would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Unknown geen idee 1,757 on at

Like
a
(1)

Report
Copy link

Link copied!
Dear W,
2 thoughts come to mind:
Can you not create the table anyhow starting from the first row, hardcode the columnheaders and then remove the first row (if needed). Not sure if this can work, worth a try.
Can you not use an office script to remove the first row ... then you are good to go. For use of office scripts in PowerAutomate there should be plenty of tutorials.
Hope this helps,
Happy flowing,
Koen

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Koen5 thanks, I ended up using the Run Script option in PA and created a tiny script to remove the first row!

Was this reply helpful? Yes No