This channel is a gold mine for power platform developers. Love your videos. The contents that you provide is no where to be found on RUclips. Thanks Dhruvin for the amazing content.
Thanks. You just made me come out of despair on a delivery. I needed to produce hundreds of sheets with information from a huge excel. I thought it would take 3 days to make. With your teaching I only needed 3 hours. And it's done! Thank you very much! Ps: The calm and direct way you conduct the session helps a lot. Congratulations.
Thank-you, Thank-you, Thank-you! I have been trying to figure this out for so long. Great step by step demo for someone who doesn't know how to write scripts and only has a basic understanding of Power Automate!
Hi Dhruvin, Thank you so much for thid video. can you create a vedio how to read data from excel and create a reprot for each user and send an email to each user
Hi Dhruv, Could you advise if k can automate the excel workbook itself . different departments to fill up the details in the same file. What would be the best approach to automate this ?
Hi Dhruvin how are you! I am new to power automate and have been loving your youtube tutorials. I have been able to successfully implement your 'Populate Excel Template using Power Automate and Office Script' except for one very strange thing. When I set my trigger and add a condition to only trigger automation when I column value changes to paid, it triggers the automation but always selects the row from the list that was last changed before the row I just changed. It is consistent every time. Even if I wait an hour and change the column of a different row again it always selects the information from the previous change. Any ideas why this would be happening? Why is it not selecting the row with the latest change?
Hi Dhruvin. Thanks to take the time for explianing this. It was very helpful for me. I was also trying to convert the XLSX file to PDF but and then email it but it is not working for me. Is this possible?
thanks for great videos, i would to ask why there is error like this "We were unable to run the script. Please try again. The script couldn't create a connection with Excel. Please try again." thanks
Hi I have a table whose entries are dynamic how can I populate data for that and also at the end of a table I need perform sum of one column values how can I achieve it
Great video sir .can we help with these question sir. 1.if max storage of a site in share point is 26.5 TB means whats is the size of sub site in share point online? and how many sub sites can we create in share point online?
Thank you Dhruvin, This is awesome now we can popoluate both now in word and excel. When I tried to run i have this error We were unable to run the script. Please try again. Workbook not found. Where did I go wrong.
Hi sir, first of all thank you for this video. I followed you step by step and everything seems to work but I have a problem. Even if the excel is populate, I can't opened it andI have this error: "Cannot open this workbook because the file format may not match the file extension." I do name my document with .xlsx I try by naming it .xls and it seems to work with this weird format, but I looked in every forum and video and can't found how to solve this error. Can you help me please. Thanks again !
So i seem to be getting an inconsistent run. I'm trying to do something similar by selecting rows in a spreadsheet table to use. When i do them 1 or 2 rows at a time it works, but if when doing larger groups (4+) it seems to skip running the script for some files. it creates the file from the template, but then doesn't populate it. However, its inconsistent - skipping row 2 sometimes and row 4 others. Any ideas?
It is really wonderful solution provided by you to generate the excel report. While running this solution in power automate, I am facing following issue in "Run Script" step We were unable to run the script. Please try again. The script couldn't create a connection with Excel. Please try again. clientRequestId: 73e35894-287d-4d73-9e12-c5cb40c4136c I also tried adding checkout/checkin step before and after "Run Script" step but no luck Please help. Thank you once again for useful video
![[TF2] The Russian Bear Trap](http://i.ytimg.com/vi/YFNSwz2_rOA/mqdefault.jpg)
Dhruvin, you are the only person that I could find that could offer a viable solution and demonstrate it perfectly. THANK YOU!!!
This channel is a gold mine for power platform developers.
Love your videos. The contents that you provide is no where to be found on RUclips. Thanks Dhruvin for the amazing content.
Great video!!!
Really really helpful
Thanks. You just made me come out of despair on a delivery. I needed to produce hundreds of sheets with information from a huge excel. I thought it would take 3 days to make. With your teaching I only needed 3 hours. And it's done! Thank you very much!
Ps: The calm and direct way you conduct the session helps a lot. Congratulations.
Thank-you, Thank-you, Thank-you! I have been trying to figure this out for so long. Great step by step demo for someone who doesn't know how to write scripts and only has a basic understanding of Power Automate!
It's very good solutions for a supervisor while doing one on one discussion and documentation. This is really a problem solving solution for me.👍
Awesome session Dhruvin! On a separate note, I love your new recording setup!
Thanks a lot!!
Thanks Dhruvin for the session! It's amazing
Thanks!! Glad it is useful
Excellent & simple. It worked for me. Thank you bro. God bless.
Awesome session, thank you Dhruvin 👏🏻
Thanks
Thanks a lot sir!! Excellet job teaching to all of us!!!
Very helpful! I am putting this into production today. ⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐
Thanks Dhruvin, this was an excellent video.
Thank you. Awesome job Dhruvin ⭐⭐⭐⭐⭐
Thanks for watching
Thank you. Very good tutorial, very clear 😀👏
Excellent, Thanks bro.
Thank you very much! :O really great way how to automate lots of processes.
Glad it was helpful!
Thank you this was super helpful for the project I'm working on
Perfect, thank you
Classic Example!!
Thank u so much !!
helpful, thanks
Thanks, very useful, can we insert picture from attachment?
Fantastic
Hi Dhruvin, Thank you so much for thid video. can you create a vedio how to read data from excel and create a reprot for each user and send an email to each user
Hi Dhruv,
Could you advise if k can automate the excel workbook itself . different departments to fill up the details in the same file. What would be the best approach to automate this ?
Thank you for your video, can we add picture to the script Dhruvin? can you make the tutorial video ?
Hi Dhruvin how are you! I am new to power automate and have been loving your youtube tutorials. I have been able to successfully implement your 'Populate Excel Template using Power Automate and Office Script' except for one very strange thing.
When I set my trigger and add a condition to only trigger automation when I column value changes to paid, it triggers the automation but always selects the row from the list that was last changed before the row I just changed. It is consistent every time. Even if I wait an hour and change the column of a different row again it always selects the information from the previous change. Any ideas why this would be happening? Why is it not selecting the row with the latest change?
Hi Dhruvin. Excellent video. Is there a way to take the file and attach it to the item in the list as an attachment instead of sending it as an email?
Yes, you can
How do i do this
@@iamdhruvinshah
Hi Dhruvin. Thanks to take the time for explianing this. It was very helpful for me. I was also trying to convert the XLSX file to PDF but and then email it but it is not working for me. Is this possible?
thanks for great videos, i would to ask why there is error like this "We were unable to run the script. Please try again.
The script couldn't create a connection with Excel. Please try again." thanks
Hi I have a table whose entries are dynamic how can I populate data for that and also at the end of a table I need perform sum of one column values how can I achieve it
Great video sir .can we help with these question sir.
1.if max storage of a site in share point is 26.5 TB means whats is the size of sub site in share point online? and how many sub sites can we create in share point online?
Thanks! I don't know the answer!! So sorry
Very useful video, thank you🤩😘💯
Thank you Dhruvin, This is awesome now we can popoluate both now in word and excel.
When I tried to run i have this error We were unable to run the script. Please try again.
Workbook not found. Where did I go wrong.
Try to run the script manually in excel first
You can find errors easily
My assumption is you did not get your sheet context
@@iamdhruvinshah no errors when I press run
👍
Hi sir, first of all thank you for this video. I followed you step by step and everything seems to work but I have a problem. Even if the excel is populate, I can't opened it andI have this error: "Cannot open this workbook because the file format may not match the file extension."
I do name my document with .xlsx
I try by naming it .xls and it seems to work with this weird format, but I looked in every forum and video and can't found how to solve this error.
Can you help me please. Thanks again !
So i seem to be getting an inconsistent run. I'm trying to do something similar by selecting rows in a spreadsheet table to use. When i do them 1 or 2 rows at a time it works, but if when doing larger groups (4+) it seems to skip running the script for some files. it creates the file from the template, but then doesn't populate it. However, its inconsistent - skipping row 2 sometimes and row 4 others. Any ideas?
I don't find 'automate' in my Excel online, please help me
I'm facing unexpected error while saving the records kindly help me thanks
It is really wonderful solution provided by you to generate the excel report.
While running this solution in power automate, I am facing following issue in "Run Script" step
We were unable to run the script. Please try again.
The script couldn't create a connection with Excel. Please try again.
clientRequestId: 73e35894-287d-4d73-9e12-c5cb40c4136c
I also tried adding checkout/checkin step before and after "Run Script" step but no luck
Please help. Thank you once again for useful video