cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mikepilgrim
Level: Power Up

Create documents from powerapps

Hello 

 

I am new to powerapps and I have a very simple question which doesn't seem to be answered anywhere 

 

My business is editing fiction books. I produce a Word doc report for my clients about their book. A lot of this is standard paragraphs which can be stored in a database and then mail merged into a document. And some has to be written / edited. I can do this with access and word but I want my employees to be able to produce their own text doc reports using the same database of paragraphs. Can I do this with powerapps? I don't know how to code. 

 

The report document is made from a bank of multiple fields and is structured the same each time. 

 

For example, let's say there's a section of the report called 'dialogue issues' - When my staff go on the app, I would like them to have a drop down selection of: 'no issues', 'minor issues' or 'lots of issues' then depending which they select the correct paragraph is inserted into the document. Or inserted into the database and then I can produce the document from the answers they've given. 

They'd also need the ability to edit the text provided from their selection. 

 

Is that possible and how difficult / easy is it? 

7 REPLIES 7
mikepilgrim
Level: Power Up

Re: Create documents from powerapps

Also, my employees work remotely 

Re: Create documents from powerapps

@mikepilgrimIt is possible to take metadata from PowerApps and write it to a Word Document. The document will not update if you make changes. 

 

I'm working on a process right now, but it's rather time consuming. 

mikepilgrim
Level: Power Up

Re: Create documents from powerapps

@BrendonBrooksP1 

 

Thanks Brendon 

 

If it makes it easier, my employees could maybe just update the database (with fields pre-filled in depending on their selection, and they can add to / edit) and then I could produce the document myself based on the fields they provide? 

 

Are you working on it for me? Or are you just generally working on it? 

If it doesn't already exist, I'm sure there's lots of companies that would pay for such a thing. 

 

 

 

Re: Create documents from powerapps

I'm just generally working on it for a few projects with PowerApps. 

 

Essentially, one of my users would fill out a form, and that data would get sent to both a SQL database and a SharePoint list. Then, the list data is populated into a Word document using Flow.  The trouble that I'm having is getting the metadata to populate to the right part of the word document. 

 

PowerApps is still a work in progress and many features that would be awesome to have, such as this one, aren't easily available or just do not exist at this time. The PA team is still working on a lot of these features. 

mikepilgrim
Level: Power Up

Re: Create documents from powerapps

ok cool - have you used mail merge with excel much? It's pretty powerful - it's kind of the same thing I think, but I think you're the expert here, so apologies if I'm preaching to the priest 😉 

Please can you post here or email me when you're finished. pilgrimist@outlook.com 

 

Thank you 

Re: Create documents from powerapps

Trust me, I'm far from an expert around here.  Just slightly smarter than the average bear. 

mikepilgrim
Level: Power Up

Re: Create documents from powerapps

Look at mail merge from a Word doc, using excel data - It's pretty awesome. It has some issues with sometimes putting a load of decimal points from a number field but with access it's pretty much flawless. With my last business everything was run from a spreadsheet (eventually we upgraded to ms dynamics) and we produced about 1000 letters a week - all different types but all from mailmerge 

Helpful resources

Announcements
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

Top Solution Authors
Top Kudoed Authors
Users online (6,735)