I'm new to Power Automate and this maybe a novice question but, I would appreciate any guidance on it.
I'm trying to create a Word and pdf document from an Excel spreadsheet. The Excel file is on SharePoint. I would like this to be a scheduled workflow running every 4 months. The Word and pdf document would need to be saved on SharePoint as well.
The columns and rows are like below. The objective is to have the workflow run a loop based on column4. If column4 is the same value, I need for the Word document to create a table for all values from column1, column2, column3, and column5 corresponding to column4. The loop would need to run through the entire spreadsheet and create multiple documents for every unique value in column4.
| column1 | column2 | column3 | column4 | column5 |
| a | d | g | ab | email |
| b | e | h | ac | email |
| c | f | i | ab | email |
I already have a template for the Word document that I would like to use but I'm not sure how to create a workflow in Power Automate for this. Word MailMerge wouldn't work in this situation for me because I don't want individual statements for each row but rather a single document containing the table of interest.
Appreciate any help on this
