Hello, complete newbie here 🙂
I need to copy/extract text from around 15 cells (from one row) of an Excel spreadsheet in Onedrive, and using that information, create and populate a Word document in Onedrive using a pre-built template. Is that possible?
I can't seem to find any help on exactly what I need to do. I literally know nothing, have no idea where to start, and after a day of researching help articles am no wiser. If anyone could let me know how to do this or point me in the direction of an exact help/example, that would be great.
Huge thanks 🙂
First you need to decide which trigger should execute your flow. Are you gonna execute it manually? Do you want it to be executed everyday at the same time? Do you want it to be executed when a new excel file is uploaded to your OneDrive?
Then for the second part (read a table on a well known Excel file) I would recommend to use 'List rows present in a table', please read this thread carefully
For the third part (populate the info in a word template) I would recommend this other
Hope this helps
Hope this helps
If you just need to get one row in the Excel file to put it into the doc file, you could refer to the following steps:
1. Get the row according to the key value of the Key column;
2. Put these columns into the Compose action to structure an object array;
3. Create an HTML table;
4. Put the table into the content of the new doc file.
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@efialttes Thanks so much for your reply, I will take a look at the links you posted. The information would always be taken from the same Excel file, but from new rows as I populate them with the relevant info. I would like to trigger it by having a column in the spreadsheet which reads e.g. [Doc Export = Yes] for the row(s) where I want to export the data from and create a new document.
I guess ideally would let the process run (and the documents be created) then once it's happened, change [Doc Export = Yes] to [Doc Export = Complete]. The process would then start again when I add [Yes] to the next/new rows.. (which could be the same day or next week.. etc..) Does that make sense?
Thanks again for the information. Unfortunately I will have to leave it there I'm afraid as I am unable even to locate my document on the first step of [List Rows Present in a Table]... and that's just the first hurdle. I simply don't understand enough about this entire process and unfortunately don't have weeks to spend researching it. I do appreciate your help though.