Power Automation Help

[lushiel]

I am attempting create an automation (power automate) and an excel script?

I am attempting to automate from a list to open an excel template, insert approx 5-10 inputs into specific cells from that list and then save as a new document.

@SudeepGhatakNZ 

[SudeepGhatakNZ]

@lushiel 

Thanks for tagging.

You first need to create an excel file with the same columns as the SP list.

Please ensure that the Excel file has a table. I can assist you then.

[lushiel]

Ok I have the list in excel and placed in SP

[SudeepGhatakNZ]

You need to foolow the following steps.

1. Create a copy of the template in a SharePoint folder using Copy file action

2. Use Get items to retrieve the values for SP

3. Run a Apply to each loop and reference the Add a row into a table action

Specify the table you created in excel. 

action

[lushiel]

thanks Sudeep, Sorry I am really not proficient in this platform and need some extra guidance working through the program. Would you be available over a teams call or other? by chance?

[SudeepGhatakNZ]

Sent you an invite

[lushiel]

As discussed here is the attachment

[SudeepGhatakNZ]

@lushiel ,

Please use the attached template.

You can import the flow from here.

Step 1: Copy the Row List and Template into OneDrive.

Step 2: Create a Folder named Excel Sheets in your OneDrive.

Step 3: Update the OneDrive references in the flow

Your individual files will be created in the Excel Sheets folder.

[lushiel]

ok thats great; I am almost there; except i am note sure what to insert into "Table" throughout the flow? and then in get tables the "Document Library"

[SudeepGhatakNZ]

You need to use the dropdown. You should see the table defined in your Row Lists excel. Most probably it is named Table1.

[lushiel]

i am still having problems. I am so sorry I have been researching this inbetween and there is no Table 1?

[SudeepGhatakNZ]

When are you available today?

[lushiel]

whenever you are free

[SudeepGhatakNZ]

I have sometime now. You can jump into the same bridge I shared earlier

[SudeepGhatakNZ · Accepted solution]

Ok, so we got it working at the end.

1) We replaced the OneDrive Copy File action with SharePoint action

2) We added a table in the Templates file

3) We corrected the references to the File property in the SharePoint actions.

[SudeepGhatakNZ]

Are you still struggling?

[lushiel]

yes just been trawling the internet!

[SudeepGhatakNZ]

send me you email, I will send an invite.