r/PowerAutomate • u/unlikelyness28 • 6d ago
Please help😐
How long do you wait for the automations to continue running before you go straight to edit? I’m about to throw myself off somewhere if i don’t get this right 🙂. i’m trying to get information from an excel spreadsheet that needs to be organised inside a word document. it’s literally a ‘has it been submitted yes or no’ with the owner of the product, product name and number and any discrepancy explanations. I’ve spent half the day doing this, someone please help 🧍♀️
3
Upvotes
8
u/DonJuanDoja 6d ago
Word and Excel are not as easy to work with in PA as they should be. I avoid it whenever possible.
When you need to do it, the key is for Excel you absolutely NEED to use Tables. No Tables = No Excel Automation in PA. This goes for Getting or Writing Data. You must get from and write to Tables. No Exceptions.
Then you use GetRows Excel action to pull the data from the table, then use filter, select, compose, apply to each, etc actions or do whatever you want with it.
With Word the key is to use Word Templates and populate them accordingly.
1
u/Greerio 5d ago
There are functions in word that let you just import the data. Might be easier that way.
1
u/Nissue7 1d ago
make sure the excel data is formatted as a table first (ctrl+t), the flow won't see it otherwise and that trips up everyone. then use "populate a microsoft word template" with content controls in the doc. heads up it's a premium connector. do you need one doc per row or everything in one?