Before investing hours learning Power Apps.

[Varik]

Hey all,

In my company, we are using VBA code in MS Word to create reports based on a template.

Concretely, people are doing their missions and after that, they come back in the office and type the mission report.

It creates a report with a code, a name, a date, the witer and a PNG signature.

Is it possible to replace this generator by an app which allow the user to enter some informations, import datas and generate a Word document with these informations.

And after copy this doc on a specific SharePoint.

Thank you in advance.

[Pstork1]

Yes it is possible.  The one issue would be that to generate it as a Word document would require either a third party connector or a premium license (per app or per user).  You could generate a PDF document with just a standard connection, but to interact with Word will require a premium license.

[RandyHayes]

@Varik 

Yes, you can do all of this in PowerApp - but, you might be looking at this slightly different.  PowerApps is not part of Word nor does it interact with Word.  It gathers data and stores it.  So, if your App was to collect the relevant information from the users and store it in a list, you could utilize PowerAutomate to pick up that record and then produce a Word document and then store it in a document library.

I hope this is helpful for you.

[Varik]

Hey,

Thank you for the quick answer.

Maybe we can stop using MS Word. 

The man goal is to create a PDF document to send to the customer.

The advantage using MS Word is to fill all the texts fields (many of them). And because completing a Word document is easy for everybody. I'm starting investigating it and it looks pretty difficult for me.

What reading can you advise me to learn it?

Is it ok to spend time for Power Platform certifications?

[Pstork1 · Accepted solution]

Take a look at the following video by Shane Young on producing a PDF using Power Automate.  As @RandyHayes said, you'll use Power Apps to collect the information and then create the document using Power Automate.  The document can then be output to OneDrive, SharePoint, or Email.

PowerApps PDF Generator using Microsoft Flow PDF Converter - YouTube

[RandyHayes · Accepted solution]

@Varik 

Yes, the referenced video by @Pstork1 is a good place to start.  It will give you the basics of what you need to contemplate your solution.

I would spend time getting up to speed on the platform before going after the certifications.

[Varik]

Thank you two for the answers.