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?
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
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?
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.
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??
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
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
You can search for individual cells and highlight them, albeit I have only done this on the first result in testing. Take a look here powerusers.microsoft.com/t5/Building-Flows/Creating-a-flow-to-find-a-couple-of-cells-in-Microsoft-Excel/m-p/924819#M129889
@@ikmalfikri666 you would have to give it a go, the recording tool is great for understanding the logic and structure of Typescript. Maybe I will explore scripts further if I get a good use case.
It will most likely be possible. Office Scripts are just that, scripts, so you write them to your requirements, including the input parameters. Check out the resources here learn.microsoft.com/en-us/office/dev/scripts/resources/samples/samples-overview
![Gucci Mane & Sexyy Red - You Don't Love Me [Official Music Video]](http://i.ytimg.com/vi/j7IBqyFKT4c/mqdefault.jpg)
Very clear demo. Thanks!
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?
Please check out pnp.github.io/blog/post/excel-scripts-and-cloud-flows-data-manipulation/
Thanks for sharing. Very good content.
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
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?
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?
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.
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
I would recommend you ask on the forum powerusers.microsoft.com/
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??
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
You would want to look at robotic process automation, ie power automate desktop.
@@DamoBird365 Thanks for replying, i was starting to go down that route, but wanted to make sure before going down the wrong rabbit hole!
will this work with an xls file too?
As xls are the older desktop version, you have to convert to xlsx before running power automate on them
@@DamoBird365 thanks.
Can u please share the flow including the script?
Scripts are all here techcommunity.microsoft.com/t5/microsoft-365-pnp-blog/excel-scripts-and-cloud-flows-data-manipulation/ba-p/2356956
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
You can search for individual cells and highlight them, albeit I have only done this on the first result in testing. Take a look here powerusers.microsoft.com/t5/Building-Flows/Creating-a-flow-to-find-a-couple-of-cells-in-Microsoft-Excel/m-p/924819#M129889
@@DamoBird365 thanks..does the same concept apply if i want to delete based on the data?
@@ikmalfikri666 you would have to give it a go, the recording tool is great for understanding the logic and structure of Typescript. Maybe I will explore scripts further if I get a good use case.
@@DamoBird365 alright..thanks
3:50- examplevar1-4
1:30- is there any way I can define my array in Office Script instead of Power Automate?
It will most likely be possible. Office Scripts are just that, scripts, so you write them to your requirements, including the input parameters. Check out the resources here learn.microsoft.com/en-us/office/dev/scripts/resources/samples/samples-overview
@@DamoBird365 Thanks. What I'm trying to do is at line 45 at 7:16. Thanks for all your help.
And line 57 at 8:25.
7:03- Why doesn't const formattedrow work for me? When I write it, it underlines formattedrow in red.