News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Dynamically Populate v...

Power Automate - General Discussion

Answered

Dynamically Populate values from multiple rows in a sharepoint to a Word Document

Like (0) Share

Report

Report

Posted on 17 Apr 2024 13:42:55 by gstredny

134

Hello,

I am creating invoices that could have multiple rows with multiple parts:

I am trying to populate this into a table for each invoice for a Word Document, but not sure how to do it for multiple rows?

I typically just have one row and do this:

I was told to craft an array and apply to each but a bit stuck on how to Append to array variables:

All responses Img

All responses (6)

Answers Img

Answers (1)

gstredny 134 on 18 Apr 2024 at 13:07:15

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

Great thank you, I will try that
Verified answer

SudeepGhatakNZ 14,318 Most Valuable Professional on 18 Apr 2024 at 00:40:40

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

My list

My template

Title

Parts And Labor

Item No

<<foreach [contract in datum]>><<[contract.Title]>>

<<[contract. PartsAndLabor

]>>

<<[contract.itemNumber]>><</foreach>>

The flow:

I have simply added the output of the array variable in a compose and passed it as a data object to Encodian

Final Output
gstredny 134 on 17 Apr 2024 at 21:28:34

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

This is a Sharepoint List
SudeepGhatakNZ 14,318 Most Valuable Professional on 17 Apr 2024 at 21:25:22

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

Okay let me try
gstredny 134 on 17 Apr 2024 at 21:17:01

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

My source data looks like this:
SudeepGhatakNZ 14,318 Most Valuable Professional on 17 Apr 2024 at 21:10:47

Like (0)

Report

Re: Dynamically Populate values from multiple rows in a sharepoint to a Word Document

Can you provide me the source data. I'll see if I can build sample for you

Helpful resources

News and Announcements

🌸You're Invited: Community Spring Festival Awards Celebration 🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,763 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,091 Most Valuable Professional

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans