The logical progression between your videos is mind blowing, I've never seen such clever thought process in the making of subsequent videos in youtube, almost like a course ! as a side note I would like to see how you would analyze the result of a customer survey through office script configured excel template(after being automatically populated)
DAAAAAMMMMMIIIIEEEENNNNNNN!!!!! TYSM... since 9 days I'm looking for this! I watched so many videos, I tried so many other things included http-requests... TY TY TY TY for this idea! The most difficult action was at least this morning to convert the excel script to my excel template :-)))))))) unpayable! Thanks a lot Damion
Oh An, thank you 🙏 it’s really nice to get feedback and especially this appreciative. Let me know if you have any other challenges. I’m always looking for video ideas. 👍
Hello Damion, thank you so much learned very important useful needed flow. and run it first time after importing the solution all because of your gold explanation wow, to be honest i have watched so many other UA-cam about flow and you know what, none of them will even came close to you, and honestly teaching. GOLD MEDAL TO YOU
2 роки тому+1
Great demos Damien, btw have you looked at YT API, I am wondering if it can be done with Power Automate that when a video is published as private (and its video description contains #PowerAutomate) the flow will kick off and check if it rendered to at least Full HD and automagically change its status to Public?
I’ve not looked at an api, but agree, I was too keen to get this one out there. I can set a future release date via the UA-cam ui, I just couldn’t wait. Noted.
Thank you for the videos!… I am running into a problem I hope you can help with. The flow creates and populates the Word document perfectly. I’m saving it to my OneDrive as .docx. I get an error “A file error has occurred” when I edit it in the Word App. I am able to edit it through Word Online.
That’s a strange one, doesn’t open in Word Desktop but does on Word Online? I would ask on the forum and please report back when you get a solution. Have you asked someone else to open up the file via their Desktop?
Hi Damo, you have a video where you take arrays in the back end of a flow and put the payload in a generator and it turns into an array, right? I'm having the darndest time finding it.
@@DamoBird365 Oh thanks, I think it was something like this. Anyway I found it. You'll be happy to know that after two years (on and off) of working on this flow, I am over the biggest hurdle- sending multiple attachments to e-mail that were created in office script (but from Power BI, not Sharepoint). A huge thanks to you for a big chunk of that.
Check out the description, I believe I have shared a downloadable version and there are links to videos where I demo some of these examples in more detail.
Hi Damo, I'm nearing the end of this behemoth Office Script / Power Automate project .... maybe. I have someone who likes to print out these templates when they're e-mailed to him, but it doesn't automatically fit to page, and it doesn't print the second worksheet as page 2 on the reverse. It just prints worksheet #1. Do you know if there's a way to code how it should be printed? I find the print options rather limited in Excel online for Business.
Hi! I've discoverd PowerApp with your video. I'm interested in testing your solution and I've downloaded your zip file. However how do I load your zip file to PowerApp to recreate the interface at 1:07 ?
Folk seem to be having problems importing the solution. I’ll try and look at weekend. Alternatively you can unzip the file and get the msapp file and import to PowerApps.
I've now uploaded both legacy exports for the flow and power app seperately and a new copy of the solution which should hopefully allow you to get up and running. Please report back.
Hey Damo have you created a video which will take my responses from an MS form and then use those responses to be plotted into the appropriate excel cells that I need Then convert to a pdf ? If so can you link please I’m struggling with this one…
I don’t have an exact example, but you probably want to use excel office scripts to pinpoint precise cells. ua-cam.com/video/Q7GLQnvJJF0/v-deo.html or ua-cam.com/video/CZFLjy8hEx0/v-deo.html
@@DamoBird365 Hi Kristóf, Error: Import failed due to missing dependencies for CreateDocsViaPowerApps. new_sharedoffice365_bb8aa connectionreference Create Documents Via Power App Cloud flow new_sharedsharepointonline_f899a connectionreference Create Documents Via Power App Cloud flow new_shared_sharepointonline_5a362dc52068468fb34cf5e2f251167d EnvironmentVariableDefinition Create Documents Via Power App Cloud flow new_shared_sharepointonline_5a362dc52068468fb34cf5e2f251167d EnvironmentVariableDefinition Create Docs Via Power App Canvas app
Hi Damien, I have implicated this on my cart app but am stuck on Parse JSON Schema as is not same like your sample the field names, how can I change it please thanks
@@DamoBird365 Hi Damien, I have overcome Parse JSON, my last question currently we can print the excel when we hit save button at the time of creation, but how about if we needed to print the invoice from previously created orders? please help thank you so much.
Hi Damon, can you do a video where info coming from Power BI populates an excel form template that gets e-mailed to users? Like we have SQL info in Power BI that every month needs to populate some forms and e-mailed to our staff.
I’ve not currently but will add to my list. Ultimately it’s about using select to repurpose your data and create an excel doc. This might help ua-cam.com/video/RB_ySjhm9Sg/v-deo.html
Hi Damien, Great Video and thanks for sharing. I wanted to import the Solution into my Dev and build it alongside watching but I'm getting this message about 4 "Mission dependencies". 2 connection references and 2 Environment Variable Definitions. I thought it should all be part of the Solution you packaged and exported. Any steer will be appreciated as I really want to work through this. Thanks
Hi Douglas, it should have included everything needed but let me take a look over the weekend and get back to you. You might have to create or update these connections/variables from within the solution. If it works beforehand, let me know.
@@DamoBird365 I would have thought I will get the option to update the connections when I tried importing the solution but it just popped up with the error message. Is there another way to ipdate/create the connections?
@@DamoBird365 Grateful if you can look into repackaging the solution again as you said. I'll also try to extract the msapp file and manually set it up. Will let you know how I get on. Thank you
@@DamoBird365 I managed to manually import the msapp file and created the SharePoint List manually with the CustomerList data so the PowerApp is now working but the Flow is still asking for the connection reference. Maybe you can also upload the flow to you Github repo and then I'll try to install that manually as well. Thanks
@@DamoBird365 Oh sorry Damien, I didn't realize you were replying. I'm doing your tutorial for the Excel attachments, and Reza Dorrani's tutorial for the HTML table. Both things need to be included in the e-mail to our inspectors. So I have two Scopes- one for your tutorial and one for his. So do I have to use the Select connector both times? (Also, as soon as I use Power BI dynamic content, it wants to wrap all my processes in Apply to Each. I can't find a way out of that. Do you know why Power BI is so different from Sharepoint in this regard?) (Thanks for the reply!)
@@erinfield1943 no problem. I also have a video on html tables in an email too ua-cam.com/video/5msxh5Ux8DY/v-deo.html 😉 you will be getting into an apply to each as the dynamic data you are selecting is in an array. Learn more about arrays here ua-cam.com/video/G3Q1WuZTWuY/v-deo.html
@@DamoBird365 Oh shoot, I was thinking I didn't have to deal with arrays and JSON. I think I deleted all the array scripting from your sample script. This is my code- do I have arrays? function main( workbook: ExcelScript.Workbook, Loan_No: string, Property: string, Address: string, Address_2: string, City: string, Province: string, Postal_Code: string, ) {
// Get the first worksheet let sheet = workbook.getFirstWorksheet(); //Update Header of First Column sheet.getRange("B8").setValue(Loan_No); sheet.getRange("B10").setValue(Property); sheet.getRange("B11").setValue(Address); sheet.getRange("B12").setValue(Address_2); sheet.getRange("B13").setValue(City); sheet.getRange("B14").setValue(Province); sheet.getRange("B15").setValue(Postal_Code); }
That script will populate individual cells. It expects each parameter to be a single value. I guess that you are passing it values from an array [], hence the apply to each.
I like your last point very much: creating csv with extra row for invoice number - thx for including this particular functionality.
Nice one Gerald, I love hearing how these videos have helped folk, so I appreciate the time you've taken to leave a message.
The logical progression between your videos is mind blowing, I've never seen such clever thought process in the making of subsequent videos in youtube, almost like a course ! as a side note I would like to see how you would analyze the result of a customer survey through office script configured excel template(after being automatically populated)
Wow thanks Anthony, can you elaborate on your requirement? Are you looking for a visual, like a chart?
ua-cam.com/video/Tj2jasorczU/v-deo.html
Thanks a lot Damion .... it is always a pleasure to dissect your videos so helpful :-)
This is great Damo... I would like to this the same Demo.. Woow my team will love to see this
DAAAAAMMMMMIIIIEEEENNNNNNN!!!!! TYSM... since 9 days I'm looking for this! I watched so many videos, I tried so many other things included http-requests... TY TY TY TY for this idea! The most difficult action was at least this morning to convert the excel script to my excel template :-)))))))) unpayable! Thanks a lot Damion
Oh An, thank you 🙏 it’s really nice to get feedback and especially this appreciative. Let me know if you have any other challenges. I’m always looking for video ideas. 👍
Hello Damion, thank you so much learned very important useful needed flow. and run it first time after importing the solution all because of your gold explanation wow, to be honest i have watched so many other UA-cam about flow and you know what, none of them will even came close to you, and honestly teaching. GOLD MEDAL TO YOU
Great demos Damien, btw have you looked at YT API, I am wondering if it can be done with Power Automate that when a video is published as private (and its video description contains #PowerAutomate) the flow will kick off and check if it rendered to at least Full HD and automagically change its status to Public?
I’ve not looked at an api, but agree, I was too keen to get this one out there. I can set a future release date via the UA-cam ui, I just couldn’t wait. Noted.
Thank you for the videos!… I am running into a problem I hope you can help with. The flow creates and populates the Word document perfectly. I’m saving it to my OneDrive as .docx. I get an error “A file error has occurred” when I edit it in the Word App. I am able to edit it through Word Online.
That’s a strange one, doesn’t open in Word Desktop but does on Word Online? I would ask on the forum and please report back when you get a solution. Have you asked someone else to open up the file via their Desktop?
Hi Damo, you have a video where you take arrays in the back end of a flow and put the payload in a generator and it turns into an array, right? I'm having the darndest time finding it.
From an api? Learn how to bring external API's to your Power App using HTTP Action & Power Automate
ua-cam.com/video/j1oltGcJJtU/v-deo.html
Or JSON Arrays in Power Automate: Learn Common Techniques & Solve 5 Challenges!
ua-cam.com/video/G3Q1WuZTWuY/v-deo.html
Or maybe Power Automate Join or Merge Arrays with Speed
ua-cam.com/video/R_bD8nAoJ8Y/v-deo.html
@@DamoBird365 Oh thanks, I think it was something like this. Anyway I found it. You'll be happy to know that after two years (on and off) of working on this flow, I am over the biggest hurdle- sending multiple attachments to e-mail that were created in office script (but from Power BI, not Sharepoint). A huge thanks to you for a big chunk of that.
Hi Damo, great work how do u create this Apps please can you share
Check out the description, I believe I have shared a downloadable version and there are links to videos where I demo some of these examples in more detail.
Great video 1 do you hav ea tutorial video how to create the power app : creat docs via power appsa from this video?
I’m afraid this is as detailed as I get but there are videos for most of the methods from a Power Automate perspective.
Hi Damo, I'm nearing the end of this behemoth Office Script / Power Automate project .... maybe. I have someone who likes to print out these templates when they're e-mailed to him, but it doesn't automatically fit to page, and it doesn't print the second worksheet as page 2 on the reverse. It just prints worksheet #1. Do you know if there's a way to code how it should be printed? I find the print options rather limited in Excel online for Business.
Check out 👀 Create professional PDF in Power Automate using Office Scripts (Non Premium)
ua-cam.com/video/CZFLjy8hEx0/v-deo.html at about 20m 30s 👍
@@DamoBird365 Oh sweet, thanks!
can the invoice be shown on the body of the email instead as an word attachment? but not in html table.
@@sumsumtulang25 yes, you could create an email with the invoice details instead of generating a file and attachment.
Hi! I've discoverd PowerApp with your video. I'm interested in testing your solution and I've downloaded your zip file. However how do I load your zip file to PowerApp to recreate the interface at 1:07 ?
Folk seem to be having problems importing the solution. I’ll try and look at weekend. Alternatively you can unzip the file and get the msapp file and import to PowerApps.
I've now uploaded both legacy exports for the flow and power app seperately and a new copy of the solution which should hopefully allow you to get up and running. Please report back.
Great video,
Thank you for sharing,
too bad I'm a very beginner and I can't apply the flow in powerapps
Hi there, it’s available to download and import, if you are unsure as a beginner about how to build but this is a more complex solution for sure.
Hey Damo have you created a video which will take my responses from an MS form and then use those responses to be plotted into the appropriate excel cells that I need Then convert to a pdf ? If so can you link please I’m struggling with this one…
I don’t have an exact example, but you probably want to use excel office scripts to pinpoint precise cells. ua-cam.com/video/Q7GLQnvJJF0/v-deo.html or ua-cam.com/video/CZFLjy8hEx0/v-deo.html
Hello Kistóf, great video! Very helpfull! I wanted to import the example, but it is not uploading. Importing the MSAPP file is working. any ideas?
Hi Frans, I’ve exported it as a solution. Are you able to import into Dataverse? Can you tell me what’s not working?
@@DamoBird365 Hi Kristóf, Error: Import failed due to missing dependencies for CreateDocsViaPowerApps.
new_sharedoffice365_bb8aa connectionreference Create Documents Via Power App Cloud flow
new_sharedsharepointonline_f899a connectionreference Create Documents Via Power App Cloud flow
new_shared_sharepointonline_5a362dc52068468fb34cf5e2f251167d EnvironmentVariableDefinition Create Documents Via Power App Cloud flow
new_shared_sharepointonline_5a362dc52068468fb34cf5e2f251167d EnvironmentVariableDefinition Create Docs Via Power App Canvas app
Hi Damien, I have implicated this on my cart app but am stuck on Parse JSON Schema as is not same like your sample the field names, how can I change it please thanks
Nice one 👍 the key names are based on your columns names or data source. Best to look back at flow history, specifically the output.
@@DamoBird365 Hi Damien, I have overcome Parse JSON, my last question currently we can print the excel when we hit save button at the time of creation, but how about if we needed to print the invoice from previously created orders? please help thank you so much.
Great works, thanks you
Which template route did you go with? Word, excel or HTML?
@@DamoBird365 Excel
Hi Damon, can you do a video where info coming from Power BI populates an excel form template that gets e-mailed to users? Like we have SQL info in Power BI that every month needs to populate some forms and e-mailed to our staff.
I’ve not currently but will add to my list. Ultimately it’s about using select to repurpose your data and create an excel doc. This might help
ua-cam.com/video/RB_ySjhm9Sg/v-deo.html
The thing is the flow will end within 30 days is there away of keeping it going?
Can you explain why you need the flow to run beyond 30 days for creating a file?
Hi Damien, Great Video and thanks for sharing. I wanted to import the Solution into my Dev and build it alongside watching but I'm getting this message about 4 "Mission dependencies". 2 connection references and 2 Environment Variable Definitions. I thought it should all be part of the Solution you packaged and exported. Any steer will be appreciated as I really want to work through this. Thanks
Hi Douglas, it should have included everything needed but let me take a look over the weekend and get back to you. You might have to create or update these connections/variables from within the solution. If it works beforehand, let me know.
@@DamoBird365 I would have thought I will get the option to update the connections when I tried importing the solution but it just popped up with the error message. Is there another way to ipdate/create the connections?
Good question. I think you might be able to export the zip and import the Power App msapp file manually. Not sure about the flow.
@@DamoBird365 Grateful if you can look into repackaging the solution again as you said. I'll also try to extract the msapp file and manually set it up. Will let you know how I get on. Thank you
@@DamoBird365 I managed to manually import the msapp file and created the SharePoint List manually with the CustomerList data so the PowerApp is now working but the Flow is still asking for the connection reference. Maybe you can also upload the flow to you Github repo and then I'll try to install that manually as well. Thanks
Nice video
Cheers Rebecca. 👍
8:41- Word template
12:41- Excel template
Hi Erin, did you find what you are looking for?
@@DamoBird365 Oh sorry Damien, I didn't realize you were replying. I'm doing your tutorial for the Excel attachments, and Reza Dorrani's tutorial for the HTML table. Both things need to be included in the e-mail to our inspectors. So I have two Scopes- one for your tutorial and one for his. So do I have to use the Select connector both times? (Also, as soon as I use Power BI dynamic content, it wants to wrap all my processes in Apply to Each. I can't find a way out of that. Do you know why Power BI is so different from Sharepoint in this regard?) (Thanks for the reply!)
@@erinfield1943 no problem. I also have a video on html tables in an email too
ua-cam.com/video/5msxh5Ux8DY/v-deo.html 😉 you will be getting into an apply to each as the dynamic data you are selecting is in an array. Learn more about arrays here
ua-cam.com/video/G3Q1WuZTWuY/v-deo.html
@@DamoBird365 Oh shoot, I was thinking I didn't have to deal with arrays and JSON. I think I deleted all the array scripting from your sample script. This is my code- do I have arrays?
function main(
workbook: ExcelScript.Workbook,
Loan_No: string,
Property: string,
Address: string,
Address_2: string,
City: string,
Province: string,
Postal_Code: string,
) {
// Get the first worksheet
let sheet = workbook.getFirstWorksheet();
//Update Header of First Column
sheet.getRange("B8").setValue(Loan_No);
sheet.getRange("B10").setValue(Property);
sheet.getRange("B11").setValue(Address);
sheet.getRange("B12").setValue(Address_2);
sheet.getRange("B13").setValue(City);
sheet.getRange("B14").setValue(Province);
sheet.getRange("B15").setValue(Postal_Code);
}
That script will populate individual cells. It expects each parameter to be a single value. I guess that you are passing it values from an array [], hence the apply to each.