What if we want to count how many rows are in the dat and use that in Power Automate to set the range. How can we do that? Why is you is that my XL range is between 20,000 rows and 40,000 rows and it would be nice not to have the extra, blank rows in the table
If your row number is always different but your column numbers are the same, you can use this formula in the Table Range field: Formula: =OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),14) You will just need to replace "Sheet1" in the formula with whatever your sheet name is, if your sheet name is something other than "Sheet1". The last number in the formula, 14, is the column number total, so you will need to change that number depending on how many static columns you have.
@ i managed to get it working for about three days and then it broke again :(
Рік тому
@@ppolarizze1762 buddy, I got it this week with a function inside of automate with name "Run Script" that belong to excel connector, it works very well and easy to apply.. it can be useful for your case too :)
What if we want to count how many rows are in the dat and use that in Power Automate to set the range. How can we do that? Why is you is that my XL range is between 20,000 rows and 40,000 rows and it would be nice not to have the extra, blank rows in the table
Is there a way to dynamically get the table range?
If your row number is always different but your column numbers are the same, you can use this formula in the Table Range field: Formula: =OFFSET(Sheet1!A1,0,0,SUBTOTAL(103,Sheet1!$A:$A),14)
You will just need to replace "Sheet1" in the formula with whatever your sheet name is, if your sheet name is something other than "Sheet1". The last number in the formula, 14, is the column number total, so you will need to change that number depending on how many static columns you have.
Are you able to populate multiple sheets with different tables?
hi! i’m trying to do this but with an automatic trigger when a new file is created in a folder. is it possible to do this?
Hey, it is my case too, did you figure out how do it?
@ i managed to get it working for about three days and then it broke again :(
@@ppolarizze1762 buddy, I got it this week with a function inside of automate with name "Run Script" that belong to excel connector, it works very well and easy to apply.. it can be useful for your case too :)
can we just replace the old data in the table with new data
I got "The resource could not be found" when i implemented as mentioned. FYI i have around 6k recs with 25 cols. Please help
Error: A table cannot overlap a range that contains a PivotTable report . Anyone know how to solve this error?
You have to delete your table and let Power Automate create it again, because it's trying to create a table inside another table.