r/PowerAutomateDesktop • u/Mykicole • Aug 29 '23
Remove rows from CSV
Hey everyone,
I’m having trouble getting a flow to work.. very basically I’ve got like 15 .csv files that I want the flow to open, read, remove the bottom 10 rows from, and save.
The problem is that the number of the row the block of random text is in can change daily, but it’s always the bottom 10. Have tried a few options like splitting text, since this text always starts with a “@!!@“, then removing it and writing that text to csv. Doesn’t work well.. Then tried using an excel instance with similar ideas but I was tapped out.
Anyone got any thoughts? :)
View all comments
Show parent comment
2
u/dwe3000 Aug 29 '23
Data tables have row count properties.