Excel Office Script Tutorial - Populate an Excel File Dynamically from Power Automate

If you have an excel file that doesn't contain a table and you want to populate select fields, individual cells, ranges, or rows, this demonstration walks you through the cloud flow and excel office script required to do this via Power Automate.

#OfficeScripts
#Excel
#PowerAutomate

[huyfe]

Hi Damo, thanks for this video. Did you write the Script? O there is way to get it simple for no coder person as it works when we populate word document?

[robdata_YT]

Thanks for sharing. Very good content.

[karthickkn]

Thanks for sharing good content. have a question, is it possible to populate separate excel file template dynamically for each row in separate cell. Basically when a row is added in excel, we need to populate new excel file template and populate the values there. Is it achievable??

[erinfield]

Do you have an example of calling an array from an Excel workbook where you haven't manually input the arrays in the back end of the flow? I'm trying to follow your code to build a table at 7:00, but I just have strings. Can I fill in a range with strings?

[notorioussamurai]

Hello, I am new to Excel scripting, is there a way to copy certain cell text when filled and save as with this name - or vice versa (when I save the file with certain name, it grabs it and inserts into certain cell)? Thanks

[LeeladharGajulapalli]

Hi Damo,

Thanks for the video 😊.

I am getting exception while i m trying to pass script name as dynamic content.

Can you please help me with this?

[gaffyh]

Is there a way to fill out an existing Microsoft Form (questionnaire) with entries on an Excel row? For example, i am having to fill out security checks on a form daily. Once performed fill out the form. AKA who did you check, then when did you check, what date etc. I've seen a lot of Forms to Excel, but not seen any Excel to Forms

[amzvintazk]

Hi Damo I have 1 concern, for example I have old data in row 2,

In this line, -->
//Populate rows below Header Row with Array Variable
const starterrow = 2; //starting row for "table" data

How can you add to row new data without overwriting old data if my starterrow is 2?
Please I need your help on this..

Thank You.

[dheaindah]

Hello Damien, do you know how to import the attachment pictures in sharepoint list to the script in excel? Please help me with this
thanks

[kareemgebriel]

Can u please share the flow including the script?

[ikmalfikri]

Hi Damien,
I have some questions regarding Office/Excel Script.
I want to check on the data for example if the data in column X=G, i want to change column Y to F
Currently i use loop where the script scan each row one by one. The process is very slow since i have large data set of 6k+.
Is there any way of this?As far as i know VBA have support of selecting visible cell after filtered but not office script.
Thanks

[EnneagramTarot-zukp]

1:30- is there any way I can define my array in Office Script instead of Power Automate?

[EnneagramTarot-zukp]

7:03- Why doesn't const formattedrow work for me? When I write it, it underlines formattedrow in red.