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.
@Koen5 thanks, I ended up using the Run Script option in PA and created a tiny script to remove the first row!
Dear W,
2 thoughts come to mind:
Hope this helps,
Happy flowing,
Koen
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2