cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChrisChong
Level: Powered On

How to export or send Powerapps record to Word template?

Goodday All,

I am looking for ideas of how to send (export) data from a PowerApps record to a Word document. Any suggestions?

I have an App in which data are recorded. I would then like to OnSelect of a button, send or export certain data to a Word document. I would apprreciate any recommendations. Is this even possible without employing Flow?  I am sure this would be useful to many others as well.

Thanking all of you for considering.

Chris

4 REPLIES 4
Highlighted
Super User
Super User

Re: How to export or send Powerapps record to Word template?

@ChrisChong 

There is no way currently to do this without the use of Flow (that I've encountered).  

 

There are a couple of options within Flow and PowerApps.

1) The Easy - Use the Plumsail Connector Works great. Is easy to implement. VERY flexible (in terms of template fill-in) Comes at a cost (subscription service)

 

2) The Challenging - Incorporate the use of Templates within a Content Type in SharePoint (or directly in the library) and create a document based on the Content Type and fill in the column values to populate the template.  No additional cost. Difficult to implement. Limited ability to fill-in the template. 

 

And a 3rd option that is relatively new on the scene is the Word Online (Business) connector.  Also claims to be able to complete a document from a Template.  I've seen no other information on it to provide details on the claim.  However, it is a Premium connector - so, all users would need a P1 license or above.

 

Hope this helps shed some light on the choices.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Super User
Super User

Re: How to export or send Powerapps record to Word template?

Hi @RandyHayes 

 

Do you have experience with the Plumsail connector?

I want to output a report, similar in concept to an Order Header / Order Detail. There will be a flixible number of Order Detail lines. I'd like to populate a Word template, to take advantage of 'Keep with Next', 'Keep Together' paragraph and table formatting to ensure presentable pagination.

Just wanted to check if you know whether the Plumail connector is capable of handling a variable number of repeating records in the body of th template? I've looked at the Word connector and it doesn't seem to do repeating sections.

 

Super User
Super User

Re: How to export or send Powerapps record to Word template?

@PaulD1 

Yes, the Plumsail connector is very flexible and can accept records and tables worth of items.

We use the connector for Word and Excel creation and it works well.  The Template is defined differently than a standard Word template, but it's much more flexible.

In reference to my posting - we started with solution #2 and it was painful.  Templates needed to be maintained at the Document Library level and if more than one was needed, then at the Content Type level.  In order to get the template to fill-in, it took a lot of work in Flow to assign the proper column values.  

With Plumsail, we simply had a Template library, PowerApps "picked" the proper Template name and that, along with a payload of JSON to Flow and we had our document created.  Tweaks to the template were easy to do since it was just a regular document in a document library.  Overall...Highly recommend it!

 

Plumsail Documents will work with DOCX, XLSX and HTML Templates.

It will generate any of the above plus PDF and can also be used to manipulate PDF files (merge, split, convert, etc.).

 

I also found their documentation and demos to be very well done and spot-on.

Some specifics to check out:

Defining templates with Plumsail.

Specifically - tables with Plumsail.

Also in the subscription are several Actions that can be taken besides just creating docs from templates.

 

They have pretty decent licensing prices and, when we put it side-by-side to the amount of work needed for the other options, it was well worth it.

 

I haven't looked at the Word (Business) Connector yet, but it seems pretty pale in comparison.  And, it requires all users of it to be P1 or above.  Plumsail charges by the document created and it is not a per user license.

 

They also have other subscriptions for things like super-pumped Flow actions and a slew of other products that are not necessarily Flow or PowerApps specific.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Super User
Super User

Re: How to export or send Powerapps record to Word template?

Thanks @RandyHayes - looks like this could be the solution I'm look for - checking it out now...

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,932)