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 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
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
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
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.
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 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/
3:50- examplevar1-4
Very clear demo. Thanks!
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
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.
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??
Thanks for sharing. Very good content.
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/
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!
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
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.
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.
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
7:03- Why doesn't const formattedrow work for me? When I write it, it underlines formattedrow in red.