Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lcjdiq2JHBwL5wcQBEqoCd
Power Automate - Building Flows
Unanswered

Empty Page in Word Template

Like (0) ShareShare
ReportReport
Posted on 20 Nov 2021 08:30:11 by 108

Hi all,

 

I am using a Populate a Word Template action to populate my data into it.

 

I have table in word document which gets populated with items from the share point list. Like example below:

 

Item NameItem No
  
  
  

 

Sometimes 2 rows filled out or some times 3 filled with data. Problem is, when there is one blank row, it should auto hide/delete so it only show filled data in the table.

 

 

Note: This is an example table with 3 rows, I have table with 20 rows that takes 2 pages. So, when there is only half data gets populated in the table, the whole pages wasted and it saves the file with blank page.  

 

 

Is there any way  I can avoid this when saving file. Please help me out on this

 

Thanks

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on 22 Nov 2021 at 22:13:21
    Re: Empty Page in Word Template

    Hi @Jackson_Dhorty 

     

    You want to use a repeating control per the video. It will handle the dynamic number of values supplied. Supply 10, get 10 rows.

     

    Damien

  • Jackson_Dhorty Profile Picture
    108 on 22 Nov 2021 at 22:03:26
    Re: Empty Page in Word Template

    To answer your question, I am using a share point list ad my data source. below are the steps i am following:

     

    1- Recurrence trigger

    2- Get item action from share point.

    3- Using "Populate a Microsoft Word template" action I am trying to map values from the last action

    4- create file in share point.

     

    Now, issue is, I have created a table (Total 20 rows) in word template consist of 2 pages. For example; if record comes with 10 rows then the rest of the table stays empty and so the page.

     

    I want to remove that empty page/table if there is any in template. Please suggest me how can I do that?

     

    Thanks

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on 21 Nov 2021 at 16:42:17
    Re: Empty Page in Word Template

    Hi @Jackson_Dhorty 

     

    Are you using a repeating control - as seen here? https://youtu.be/lBXSsEIlWok

     

    I need to understand if your data source has an empty row - if so, use a filter array where the value is not equal to nothing or if your Word Doc has a table of 3 rows - in which case use repeating controls.

     

    Please consider accepting my answer as a solution if it helps to solve your problem.

    Cheers
    Damien

    Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 105

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 84 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 62 Super User 2025 Season 1

Overall leaderboard
Loading started