Nice one Gerald, I love hearing how these videos have helped folk, so I appreciate the time you've taken to leave a message.

Wow thanks Anthony, can you elaborate on your requirement? Are you looking for a visual, like a chart? kzfaq.info/get/bejne/itBincSk1NjHqok.html

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. 👍

Which template route did you go with? Word, excel or HTML?

@@DamoBird365 Excel

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 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.

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.

Can you explain why you need the flow to run beyond 30 days for creating a file?

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?

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

Or JSON Arrays in Power Automate: Learn Common Techniques & Solve 5 Challenges! kzfaq.info/get/bejne/fZmBZLqmv7q7pY0.html

Or maybe Power Automate Join or Merge Arrays with Speed kzfaq.info/get/bejne/iMWSd5ufptWuaI0.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.

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.

Check out 👀 Create professional PDF in Power Automate using Office Scripts (Non Premium) kzfaq.info/get/bejne/ecB2f82qnc6pqGQ.html at about 20m 30s 👍

@@DamoBird365 Oh sweet, 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.

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.

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

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

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

Cheers Rebecca. 👍

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

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 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

@@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.