Understanding Merging Files (without Encodian)
I've seen mention that Encodian, or any other third-party app, isn't needed to combine multiple files from an array into one file. When looking at the simple-merge-webview-list-flow-package.ZIP, I can even see that no 3rd party app is being used to get the final singular file, but I'm having trouble understanding how it accomplishes that.
From the looks of it, the flow somehow uses the exact same action “populate a word template” along with the exact same word template that was used to generate each letter/envelope.
I could be missing something, because I always have to create new flows from these packages instead of straight importing them, but I don't see how you can re-use the same template to combine all of the individual files.
Does anyone understand how this works so I can set it up for my own flow? Further, what about merging documents that didn't have a template used to create the individual files?
Thanks for any help.
Comments
-
Aidan Lambert:
I've seen mention that Encodian, or any other third-party app, isn't needed to combine multiple files from an array into one file. When looking at the simple-merge-webview-list-flow-package.ZIP, I can even see that no 3rd party app is being used to get the final singular file, but I'm having trouble understanding how it accomplishes that.
From the looks of it, the flow somehow uses the exact same action “populate a word template” along with the exact same word template that was used to generate each letter/envelope.
I could be missing something, because I always have to create new flows from these packages instead of straight importing them, but I don't see how you can re-use the same template to combine all of the individual files.
Does anyone understand how this works so I can set it up for my own flow? Further, what about merging documents that didn't have a template used to create the individual files?
Thanks for any help.Hi Aidan,
There's two key things going on here:
- A Word Document that has the entire content in a Repeating Section Content Control
- A LetterArray variable
In the Apply to each, it is reading the details about specific gifts, uses the Word Template to fill in the specifics for each individual gift, and then taking the specifics of that gift and appending it to the LetterArray.
After those loops are done, you have an Array with all the specifics of each of the gifts. The Populate a Microsoft Word Template is then called again but passes in that array. That array in combination with the Repeating Section Content Control aspect of the Word Template is what creates the single document. It repeats the content in the Repeating Section Content Control over and over filling in the individual Content Controls with each item in the array.
It's because we're using a simple approach in which the only differences between each of the letters is the gift specifics that we can do this without a 3rd party connector literally merging individual documents.
1 -
Glen Hutson:
Hi Aidan,
There's two key things going on here:
- A Word Document that has the entire content in a Repeating Section Content Control
- A LetterArray variable
In the Apply to each, it is reading the details about specific gifts, uses the Word Template to fill in the specifics for each individual gift, and then taking the specifics of that gift and appending it to the LetterArray.
After those loops are done, you have an Array with all the specifics of each of the gifts. The Populate a Microsoft Word Template is then called again but passes in that array. That array in combination with the Repeating Section Content Control aspect of the Word Template is what creates the single document. It repeats the content in the Repeating Section Content Control over and over filling in the individual Content Controls with each item in the array.
It's because we're using a simple approach in which the only differences between each of the letters is the gift specifics that we can do this without a 3rd party connector literally merging individual documents.
Ah I see, thank you very much for explaining! That is a pretty neat way to solve the problem.
0 -
Does this work with images/media, headers/footers as well? I tried using the repeating letter when first starting out but ran into issues and ended up using Encodian's free version to merge them all instead.
0 -
Evan Webb:
Does this work with images/media, headers/footers as well? I tried using the repeating letter when first starting out but ran into issues and ended up using Encodian's free version to merge them all instead.
People in the community have reported varying success with images (and I believe I may have seen one example with header/footer). This method was developed as an alternative to not have to use a 3rd party, especially due to the timing of the changes and for many orgs this being the first time diving into Power Automate. However, many may find it easier to work with Encodian rather than working through this method, and it may be the only way to achieve what one may be looking for.
0
Categories
- All Categories
- 6 Blackbaud Community Help
- High Education Program Advisory Group (HE PAG)
- BBCRM PAG Discussions
- Luminate CRM DC Users Group
- DC Luminate CRM Users Group
- Luminate PAG
- 186 bbcon®
- 1.4K Blackbaud Altru®
- 389 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 14 donorCentrics®
- 355 Blackbaud eTapestry®
- 2.4K Blackbaud Financial Edge NXT®
- 616 Blackbaud Grantmaking™
- 542 Blackbaud Education Management Solutions for Higher Education
- 33 Blackbaud Impact Edge™
- 3.1K Blackbaud Education Management Solutions for K-12 Schools
- 909 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 207 JustGiving® from Blackbaud®
- 6.2K Blackbaud Raiser's Edge NXT®
- 3.5K SKY Developer
- 236 ResearchPoint™
- 116 Blackbaud Tuition Management™
- 375 YourCause® from Blackbaud®
- 160 Organizational Best Practices
- 232 The Tap (Just for Fun)
- 31 Blackbaud Community Challenges
- Blackbaud Consultant’s Community
- 19 PowerUp Challenges
- 3 Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 3 Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 71 Blackbaud Community All-Stars Discussions
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 743 Community News
- 2.8K Jobs Board
- Community Help Blogs
- 52 Blackbaud SKY® Reporting Announcements
- Blackbaud Consultant’s Community
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- Blackbaud Francophone Group
- Blackbaud Community™ Discussions
- Blackbaud Francophone Group