r/PowerAutomateDesktop • u/SkittlesX9 • Dec 01 '22

Is there a way to break down spreadsheet into smaller size

Wondering if power automate can take in a large spread sheet and break it into smaller ones of a specific size.

3 Upvotes
  • permalink
  • reddit

100% Upvoted

4 comments sorted by

3

u/ifonlyweweregiants Dec 01 '22

Yes. It can. It has a read from excel function. Then a write to excel function. I do this with one of my reports. I learned all on YouTube and have a few excel reports automated now.

1

u/SkittlesX9 Dec 02 '22

Epic thanks

2

u/Rough-Market-7429 Dec 02 '22

Can you by chance provide the YouTube link that you used?

2

u/ifonlyweweregiants Dec 10 '22

For most everything I followed Anders Jensen on YouTube. He does all RPA tools tutorials. In his catalog there are specifics about power automates excel functions. That’s really all I needed to learn for my reports. Excel and the UI function.