Unanswered

Populate Word Template without premium license.

(1) Share

Report

Posted on by Community Power Pla...

My client has a word template that needs to be populated using PowerApps, but all the solutions that I found on internet are through the use of Power Automate and connector used is premium connector. My client does not agree to purchase license so what options do I have?

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Verified answer

WarrenBelz 153,030 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

You can populate a Word template using quick parts and a SharePoint library as per this link from Laura Rogers @WonderLaura .

It works quite well, but is quite a task as a “duplicate” library needs to be created to house the merge criteria fields.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @WarrenBelz

Thanks for the link it works, now I am wondering how can I add repeating section in the word template and feed SharePoint list values in repeating section of word template. If you have any idea than please

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

You cannot add a repeating section with the Quick a parts process. I believe it is possible with the Premium Word connector, but I have never needed to do it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @WarrenBelz

Do you know how can I convert this generated word document into PDF format without a premium connector?

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (2)

Report

@Anonymous ,

If you save the merged Word file in OneDrive, there is a PDF conversion option in that connector.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @WarrenBelz

One last question, how can I add image in word template and populate it using SharePoint.

Was this reply helpful? Yes No
WarrenBelz 153,030 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

I can tell you with a fair amount of certainty that it is not possible with the Quick Parts process as I explored this a while back and ended using the Premium Connector (which is also a far less complex process) for embedding signatures in merged documents.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
AdamGill1965 311 on at

Like (3)

Report
In case you were searching for a way to populate a repeating section in this type of scenario - I have developed a solution that I have tested and it works:

Get your Rows from your Data Source using a Filter if necessary.
Create an Array for the entries you want to include.
Compile your Array into a Table.
Define a variable to insert a New Line between Table entries.
Use the Join Action to collect your Rows together and use your New Line variable as the separator.
Drop the Results of your Join Action into the Quick Parts elements as previously described.

If there is still interest in achieving this, I will add a step-by-step guide.

1 people found this reply helpful.

Was this reply helpful? Yes No
AdamGill1965 311 on at

Like (2)

Report
I just wanted to drop this in here because I have found a way to populate a repeating section with row data in this type of scenario:

Get your Rows from your Data Source using a Filter if necessary.
Create an Array for the entries you want to include.
Compile your Array into a Table.
Define a variable to insert a New Line between Table entries.
Use the Join Action to collect your Rows together and use your New Line variable as the separator.
Drop the Results of your Join Action into the Quick Parts elements as previously described.

If there is still interest in achieving this, I will add a step-by-step guide.

Was this reply helpful? Yes No
krusty00 8 on at

Like (2)

Report

Hi AdamGill1965,

i've tried to develop solution you suggested but html table isn't correctly complied in word quick part; i could read html code in word document: can you post step-by-step guide?

Thx

Was this reply helpful? Yes No