Automating Excel to Word data transfer for multiple records using Power Automate

Hello everyone,

I am looking for some assistance with an automation task using Power Automate. My goal is to link multiple Excel files with Word documents.

Specifically, I have several Excel files containing information for 50 different people. Each Excel file contains unique identifiers for each person to facilitate data mapping. I want to gather all this information and generate 50 Word files (one for each person) that include the various information from the different Excel files for the same person. The Word files will follow the same template.

I am wondering if this is feasible with Power Automate and, if so, if there is a tutorial or detailed instructions available for this?
I've also tried with VBA macros on Excel but I fear I may be blocked at some point.

Here's the approach I've tried so far:

=> List rows present in a table
=> Compose - to structure the data
=> Get file content
=> Compose - to analyze the Word content
=> Replace Text - to replace the placeholders with information from the Excel files
=> Update file

Unfortunately, this does not seem to work as expected. Could someone point out what might be wrong or suggest a better method?

Thank you in advance for your help!

Quick Links

Leaderboard > Power Automate - Building Flows