Monday, November 14, 2022

Generate Word Document Template Using Power Automate

 Introduction:

In this Blog am explaining how to Generate Word Template using Power Automate with Back End as SharePoint.

And am Covering how to add Repeating Controller and Plain Text Content Controller in Word Document.

 

Implementation Steps:

 

1. Navigate to your SharePoint Site and Create SharePoint List

2. In my case i have created 2 SharePoint List One is Employee and another Student

rampprakash_0-1668425443919.png

 

3. Add Records to Employee List and Student List

rampprakash_1-1668425444174.pngrampprakash_2-1668425444175.png

 

4. Now Open Microsoft Word Document 

 

5. Once Microsoft Word Opened Click on Developer in Ribbon Tool Bar 

 

rampprakash_3-1668425445219.png

 

6. If the Developer is not available then Click File --> Select Options --> Click Customize Ribbon and Select Developer --> and Click OK

 

rampprakash_4-1668425445416.png

 

7. Once Done Click Insert and Select Table

 

rampprakash_5-1668425445218.png

 

 

8. Now Input the Name in the First Column

 

rampprakash_6-1668425443674.png

 

9. Now Select the ID  then Click On Developer Ribbon Tab at the TOP then Select Add Plain Text Content Controller

 

rampprakash_7-1668425444701.png

 

10. Now Once Done Select the ID Column then Click Properties

 

rampprakash_8-1668425445215.png

 

 

11. After Clicking Properties it will Open Popup Enter Title and Tag

 

rampprakash_9-1668425445220.png

 

 

12. Once done, do the same for other Column as Well

 

rampprakash_10-1668425444424.png

 

 

13. Once Done, Now we are ready to Add Repeating Content Controller For the Table so that it will display All the Values from the List

 

rampprakash_11-1668425444687.png

 

 

14. Now Click On Properties and Provide the Tag and Title For Relating Table

 

rampprakash_12-1668425444705.png

 

 

15. The Same Way Create a New Table For Student and Add the ID and Title 

 

rampprakash_13-1668425445220.png

 

16. Now am Adding a Single Line of Text  Value as Well--> Simply add a Single Line of Text

 

rampprakash_14-1668425444173.png

 

17. Once Done Save the File in Your SharePoint Site

 

rampprakash_15-1668425445214.png

 

Once after Record Gets Created navigate to https://flow.powerautomate.com

 

18 . Click Apps --> Select New Flow --> Select Instant Cloud Flow and Input the Name as (Generate Word Template Using Power Automate) and Click Create.

 

rampprakash_16-1668425445413.png

 

19. Now Click Add Step and Select SharePoint and Search for Get Items and Add the SharePoint Site and Select List Name

 

rampprakash_17-1668425445211.png

 

20. Now Add Get Items Again and Get the Student List

 

rampprakash_18-1668425444422.png

 

 

21.Once Done Click Add Step and Search For SELECT

 

rampprakash_19-1668425444933.png

 

 

22. Now Select the Respective Values then Please make sure the EMPID and EMPTITLE As like as Properties which we have created in Point 11

 

23. Now Select Add Steps --> Search for Word then Select POPULATE A MICROSOFT WORD TEMPALTE then Select the Locations

 

rampprakash_20-1668425444723.png

 

 

24. Now for Populating REPEATING TABLE click the HIGHLIGHED BUTTON and Select the OUTPUT Values form Point 21.

 

25. Now Add Some Custom Values in Single Line of Text.

 

26. Now Send an Email 

rampprakash_21-1668425444918.png

 

 

That's it :slightly_smiling_face:

 

Now are are good to start the Process

 

rampprakash_22-1668425444944.png

 

 

Now the Flow Created Successfully. Now am Opening My Email and Downloading the file

 

rampprakash_23-1668425444704.png

 

 

Open the Downloaded File 

rampprakash_24-1668425443942.png

 

 

That's it :slightly_smiling_face:

 

I have mentioned Step by Step behaviors for How to Generate Word Document Template Using Power Automate :slightly_smiling_face:

No comments:

Post a Comment

Day 11 - Customizing Option Sets Dropdown Fields with JavaScript

  In this Blog, we will see how to Customizing Option Sets Dropdown Fields with JavaScript label1 = formContext.getAttribute( "bosch_op...