Populate Word Document from Canvas PowerApp

(0) Share

Report

Posted on by Ethan_009

4,838 Moderator

Hi everyone,

I would like to have a document generated using a template. (I know this will require power-automate)

Since I haven't done anything as of this type yet, need a response at earliest for implementation.

List of controls I have in my Canvas App are,

1. Few textboxes, labels, dropdowns.

2. I also have gallery that represents a grid

3. Also I have a gallery within a gallery which holds lookup records.

How can I achieve this with a click of a button ?

Any reference or code would be helpful.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

JayMagness 1,663 on at

Like (1)

Report

HI I have note done this but this will take a few things.

1) powerapps is not a data system and in order to do a form fill in word you need to have a data source.

2) I would use powerapps to fill a SharePoint list, then use flow to create the word document and fill the document with the data form the list out of sharepoint.

I am sure there are other ways people will have but this is the direction I would go.

Jay

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
@Ethan_R

I have used the following method to print my letters out of MS Access instead of MS Word for the last 3 years. There is a way to do it with Power Automate but that requires a premium connector. Here is a post on how to do it. https://tahoeninjas.blog/2020/03/13/generate-word-documents-from-a-template-using-power-automate/ .

Since I came to PowerApps from MS Access web apps, I was more comfortable with this method.

Create a report in Desktop access.

Open Desktop Access and create a linked table to your SharePoint list.

Highlight the table and create a query that you can use to control which data you want to use in your report, Ie. set the date range, etc. Save and name the query.

Highlight the query. You can then use the Create Report feature to create your report/merge and print it from there.

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (1)

Report

Ok great this is another way as you say, also since word is not a requirement you could look at using.

New Screen --> Portrait or Landscape Print then you can do it all out of powerapps.

just another thought.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Thanks @JayMagness and @Drrickryp will try this out.

Was this reply helpful? Yes No
pallavi41 2 on at

Like (0)

Report

Can you please share how you did that?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Hi @pallavi41 ,

Here's what I did,

I used a button to trigger a instant cloud Flow (PowerApps V2) by passing the Record GUID for which I am working actively on the Screen.

Kept a loading dialog for the flow until I get response back from the cloud flow (either success or fail will terminate loading dialog)

I carried out all complex record, related and lookup handling in my flow with several condition and later generating the Document with the template. Later, storing it to the SharePoint.

Lastly, I passed the response if success or failure back to PowerApps.

Hope this helps

Was this reply helpful? Yes No