I like your last point very much: creating csv with extra row for invoice number - thx for including this particular functionality.
@DamoBird365 Жыл бұрын
Nice one Gerald, I love hearing how these videos have helped folk, so I appreciate the time you've taken to leave a message.
@Lyriks_ Жыл бұрын
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)
@DamoBird365 Жыл бұрын
Wow thanks Anthony, can you elaborate on your requirement? Are you looking for a visual, like a chart? kzfaq.info/get/bejne/itBincSk1NjHqok.html
@guilsoumathieu8160 Жыл бұрын
Thanks a lot Damion .... it is always a pleasure to dissect your videos so helpful :-)
@basehumax Жыл бұрын
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 KZfaq about flow and you know what, none of them will even came close to you, and honestly teaching. GOLD MEDAL TO YOU
@anstolze3280 Жыл бұрын
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
@DamoBird365 Жыл бұрын
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. 👍
@thamitommy36212 жыл бұрын
This is great Damo... I would like to this the same Demo.. Woow my team will love to see this
@mohamedjemaii52922 жыл бұрын
Great works, thanks you
@DamoBird3652 жыл бұрын
Which template route did you go with? Word, excel or HTML?
@mohamedjemaii52922 жыл бұрын
@@DamoBird365 Excel
@samuel-tj4pe Жыл бұрын
Great video 1 do you hav ea tutorial video how to create the power app : creat docs via power appsa from this video?
@DamoBird365 Жыл бұрын
I’m afraid this is as detailed as I get but there are videos for most of the methods from a Power Automate perspective.
@MrDhemis Жыл бұрын
Great video, Thank you for sharing, too bad I'm a very beginner and I can't apply the flow in powerapps
@DamoBird365 Жыл бұрын
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.
@imotumbokanaka415711 ай бұрын
Hi Damo, great work how do u create this Apps please can you share
@DamoBird36511 ай бұрын
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.
@saralayoffs840911 ай бұрын
The thing is the flow will end within 30 days is there away of keeping it going?
@DamoBird36511 ай бұрын
Can you explain why you need the flow to run beyond 30 days for creating a file?
@ericleckrone7739 Жыл бұрын
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.
@DamoBird365 Жыл бұрын
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?
@erinfield1943 Жыл бұрын
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 Жыл бұрын
From an api? Learn how to bring external API's to your Power App using HTTP Action & Power Automate kzfaq.info/get/bejne/oJefn9d4yLCupIk.html
@DamoBird365 Жыл бұрын
Or JSON Arrays in Power Automate: Learn Common Techniques & Solve 5 Challenges! kzfaq.info/get/bejne/fZmBZLqmv7q7pY0.html
@DamoBird365 Жыл бұрын
Or maybe Power Automate Join or Merge Arrays with Speed kzfaq.info/get/bejne/iMWSd5ufptWuaI0.html
@erinfield1943 Жыл бұрын
@@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.
2 жыл бұрын
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?
@DamoBird3652 жыл бұрын
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 KZfaq ui, I just couldn’t wait. Noted.
@erinfield1943 Жыл бұрын
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.
@DamoBird365 Жыл бұрын
Check out 👀 Create professional PDF in Power Automate using Office Scripts (Non Premium) kzfaq.info/get/bejne/ecB2f82qnc6pqGQ.html at about 20m 30s 👍
@erinfield1943 Жыл бұрын
@@DamoBird365 Oh sweet, thanks!
@basehumax Жыл бұрын
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 Жыл бұрын
Nice one 👍 the key names are based on your columns names or data source. Best to look back at flow history, specifically the output.
@basehumax Жыл бұрын
@@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.
@antoinecompagnie66402 жыл бұрын
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 ?
@DamoBird3652 жыл бұрын
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.
@DamoBird3652 жыл бұрын
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.
@erinfield1943 Жыл бұрын
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.
@DamoBird365 Жыл бұрын
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 kzfaq.info/get/bejne/iKiPrLabzdOdg5s.html
@EBTV_23 Жыл бұрын
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…
@DamoBird365 Жыл бұрын
I don’t have an exact example, but you probably want to use excel office scripts to pinpoint precise cells. kzfaq.info/get/bejne/h513f7Sf27CudmQ.html or kzfaq.info/get/bejne/ecB2f82qnc6pqGQ.html
@frenske20022 жыл бұрын
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?
@DamoBird3652 жыл бұрын
Hi Frans, I’ve exported it as a solution. Are you able to import into Dataverse? Can you tell me what’s not working?
@frenske20022 жыл бұрын
@@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
@rebeccaj1382 жыл бұрын
Nice video
@DamoBird3652 жыл бұрын
Cheers Rebecca. 👍
@dougydoe2 жыл бұрын
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
@DamoBird3652 жыл бұрын
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.
@dougydoe2 жыл бұрын
@@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?
@DamoBird3652 жыл бұрын
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.
@dougydoe2 жыл бұрын
@@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
@dougydoe2 жыл бұрын
@@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
@erinfield1943 Жыл бұрын
8:41- Word template 12:41- Excel template
@DamoBird365 Жыл бұрын
Hi Erin, did you find what you are looking for?
@erinfield1943 Жыл бұрын
@@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!)
@DamoBird365 Жыл бұрын
@@erinfield1943 no problem. I also have a video on html tables in an email too kzfaq.info/get/bejne/a9Ojq8tmut6cdI0.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 kzfaq.info/get/bejne/fZmBZLqmv7q7pY0.html
@erinfield1943 Жыл бұрын
@@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); }
@DamoBird365 Жыл бұрын
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.