hello, good video. I have created something similar using Content Control Text fields in MS Word. My problem was how to fill all rows for each order for example without using a premium connector. I had to create a template in word similar like you, send the data using PA and then when I open the word file, the details are inside a control text. I have to use a macro to separate each row. I could see your solution and how it works and I have a question. Does your solution let send a dynamic image (stored in a list) to insert in your word template? I had this problem too, i had to create a macro (in word) to convert base64 string to image object in word. In my template I have header and footer to enumerate the pages. I needed to show the page number in pdf. I didn't find a better solution to solve my problem in that moment. So, muy solution consists in a power app and a word template with macros. I appreciate any comments and thank for your video.
Hello! Glad you enjoyed the video. Sorry for the late response. You can indeed send a dynamic image to insert into the word template. You would need to add a placeholder to your Word document for where your image should be inserted (so something like {contosoImage} in your header and footer depending on the image from your Sharepoint list). You would then pass in the image data when you populated the Word template. You would add the following to the JSON that populates the template: contosoImage: { type: "image", source: JSON(, JSONFormat.IncludeBinaryData), format: "image/png", width: , height: } Where I have "insert your image here", you would need to reference your image field from your Sharepoint list. If you're selecting something from a gallery or table, you might use something like Table.Selected.ImageField. I hope that helps!
It is definitely a complex solution! I think this has many benefits over the populate a word document action. 1. Not using a premium connector, there is no additional cost to the organization using this method. 2. I think this offers better flexibility with populating the data. I’d venture to say it’s easier to create the actual Word documents in this method than using the populate a word template action. The placeholders are just plain text, so there’s no need to open the developer tab or insert fields which you have to rename and then populate in Power Automate. There are some great advanced features of this component that I didn’t cover in this video that you aren’t able to do in Power Automate as well. 3. There’s a bit better reusability when using this component. You can store the Base64 strings of your Word templates in a data source like Sharepoint or Dataverse, and then dynamically pull the report that you want to populate. This means you could have 5 different Word documents stored, and you’re only using 1 component to populate and download them. I have a future video planned for a more advanced setup like this. 4. When combined with the file downloader component, I think this mimics what most people would be familiar with from a normal website by having the file downloaded directly in the browser instead of needing to be saved to Sharepoint/OneDrive or sent via email. I hope that helps give some insight! Let me know if you have any questions or if you decide to use this. Thanks!
Hi Getting error on download file is empty and flow error is Covert file The error indicates that the conversion action failed due to a bad request,please help also what steps do i have to take if i need only email the file directly from powerapps
Hi there! Just a quick question - are you entering the Id of the Create File action into the file property of the Convert File action? I just want to make sure of that before troubleshooting further. For emailing the file, instead of adding the "Respond to Power Apps" action at the end of your flow, you would add a Send an Email (V2) action. You would format your email, and in the attachments section of this action, you'll enter the name of your attachment in the "Attachment Name" field and the value from the video that would've been returned to the Power App in the Attachment Content field. In the video it is: body('Convert_file')?['$content']
Hello there, All Working perfectly, thank you so much! ♥
Very useful content, simple and easy to follow. Keep the videos coming!
hello, good video. I have created something similar using Content Control Text fields in MS Word. My problem was how to fill all rows for each order for example without using a premium connector. I had to create a template in word similar like you, send the data using PA and then when I open the word file, the details are inside a control text. I have to use a macro to separate each row. I could see your solution and how it works and I have a question. Does your solution let send a dynamic image (stored in a list) to insert in your word template? I had this problem too, i had to create a macro (in word) to convert base64 string to image object in word.
In my template I have header and footer to enumerate the pages. I needed to show the page number in pdf. I didn't find a better solution to solve my problem in that moment. So, muy solution consists in a power app and a word template with macros.
I appreciate any comments and thank for your video.
Hello! Glad you enjoyed the video. Sorry for the late response.
You can indeed send a dynamic image to insert into the word template. You would need to add a placeholder to your Word document for where your image should be inserted (so something like {contosoImage} in your header and footer depending on the image from your Sharepoint list).
You would then pass in the image data when you populated the Word template. You would add the following to the JSON that populates the template:
contosoImage: {
type: "image",
source: JSON(, JSONFormat.IncludeBinaryData),
format: "image/png",
width: ,
height:
}
Where I have "insert your image here", you would need to reference your image field from your Sharepoint list. If you're selecting something from a gallery or table, you might use something like Table.Selected.ImageField.
I hope that helps!
i was wonder the difference between this solution vs populate from word template? which one is better, cause I see this is complicated to setup
It is definitely a complex solution! I think this has many benefits over the populate a word document action.
1. Not using a premium connector, there is no additional cost to the organization using this method.
2. I think this offers better flexibility with populating the data. I’d venture to say it’s easier to create the actual Word documents in this method than using the populate a word template action. The placeholders are just plain text, so there’s no need to open the developer tab or insert fields which you have to rename and then populate in Power Automate. There are some great advanced features of this component that I didn’t cover in this video that you aren’t able to do in Power Automate as well.
3. There’s a bit better reusability when using this component. You can store the Base64 strings of your Word templates in a data source like Sharepoint or Dataverse, and then dynamically pull the report that you want to populate. This means you could have 5 different Word documents stored, and you’re only using 1 component to populate and download them. I have a future video planned for a more advanced setup like this.
4. When combined with the file downloader component, I think this mimics what most people would be familiar with from a normal website by having the file downloaded directly in the browser instead of needing to be saved to Sharepoint/OneDrive or sent via email.
I hope that helps give some insight! Let me know if you have any questions or if you decide to use this. Thanks!
can the same control be use in MDP as well please?
I have not tested this in Model Driven Pages, but I can’t think of anything that would prevent this from working there! I’d say give it a shot!
@@PowerAppsGuy I shall indeed. Thanks for getting back.
Hi Getting error on download file is empty and flow error is Covert file The error indicates that the conversion action failed due to a bad request,please help also what steps do i have to take if i need only email the file directly from powerapps
Hi there! Just a quick question - are you entering the Id of the Create File action into the file property of the Convert File action? I just want to make sure of that before troubleshooting further.
For emailing the file, instead of adding the "Respond to Power Apps" action at the end of your flow, you would add a Send an Email (V2) action. You would format your email, and in the attachments section of this action, you'll enter the name of your attachment in the "Attachment Name" field and the value from the video that would've been returned to the Power App in the Attachment Content field. In the video it is:
body('Convert_file')?['$content']
@@PowerAppsGuy Yes used the Id still same, please is there a way to share the flow file? Thanks
So sorry for the late reply, I missed this! Please send me an email at the email linked on my profile. I can provide the flow export to you.
@@PowerAppsGuy Thank you for the reply I have sent the email.
Thanks! Just sent you the file.