cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tilieva
Frequent Visitor

populate complex word document with information based on power apps form

Hello,

 

I would like to create an app where a manager can fill out a form about the performance of an employee and based on that information an employment reference letter is created for the employee. So in the app there is a form where the manager is e.g. asked:

 

- How would you rate the general performance of this employee? - Very good, Good, Fair

- How would you like the quality of the work done by the employee? - Very good, Good, Fair

- Etc.

 

I have attached a foto of part of the form. It is in German but it still gives an idea of what the form looks like.

 

Based on each answer selected by the manager, I would like to add a standard sentences from employment reference letters in the Word document. So if the manager selected "Very good" overall performance, the employment reference letter should e.g. say  "As an employee, [employee_name] was always reliable and responsible." If the manager selects "Good", a different sentence and so on. Furthermore,  parts of the sentences should be composed, based on the gender of the employee. So it should say "She did a good job ...."  if the employee is female and "He did a good job..." if the employee is male.

 

So, I know how to map variables 1:1 from a Power Apps form to a Word template, but not how to make the above slightly more complex described scenario work.

 

Thank you in advance,

Lina

 

1 ACCEPTED SOLUTION

Accepted Solutions
BCLS776
Super User
Super User

Yes, this can all be done using a Power Automate flow. First, make sure your app's survey results are being saved to a data source that you can access in a flow, such as a SharePoint List.

You can choose if you want to trigger the flow each time a row in the list is created/modified, or if you want it triggered directly by the app.

In the flow, start out by using Switch or Condition statements to set string variable values you will need in the letter template from the survey result record, such as:
- Preferred pronoun

- Each standardized answer

Once you have the variables set to desired values, it is a matter of populating the word document template. If you need a refresher on how to do this, this link is a good one.

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
BCLS776
Super User
Super User

Yes, this can all be done using a Power Automate flow. First, make sure your app's survey results are being saved to a data source that you can access in a flow, such as a SharePoint List.

You can choose if you want to trigger the flow each time a row in the list is created/modified, or if you want it triggered directly by the app.

In the flow, start out by using Switch or Condition statements to set string variable values you will need in the letter template from the survey result record, such as:
- Preferred pronoun

- Each standardized answer

Once you have the variables set to desired values, it is a matter of populating the word document template. If you need a refresher on how to do this, this link is a good one.

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
tilieva
Frequent Visitor

This worked, thanks a lot! 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (4,639)