SharePoint into Word Premium

[nmccool]

I am taking newly entered list items and trying to get them into a word document and then email me the Word document with the items listed; there are 1-15 list items, BUT it sends as many list items in each email. What Am I doing wrong? I have used the repeat process in Word, thought I have Flow set up correctly. Can some one help me with the steps?

[v-qiaqi-msft]

Hi @nmccool,

Could you please share a bit more about your flow?

Do you want to only send a single one email with the word document?

I guess that you may add the Send an email action within a loop, you could take it out and make it as a single action.

[nmccool]

The word doc has multiple lines needed, but it is sending an email for each line.  I have the Word doc set up with repeating from Developer

[v-qiaqi-msft]

Hi @nmccool，

I think you should add a "Create file" action to create the word file so that you could get content from it.

I have a test on my side, please take a try as below:

[nmccool]

So I tried your flow, and got an error message 

Also dont understand how to get all the lines from SharePoint to the Word template;

[nmccool]

Well, I got it down to one email, BUT I am only getting partial info on the word doc, NOT all the info entered into SharePoint (by PowerApps form) this is what is missing from Word. 

This is the ONLY info that came over into Word

[v-qiaqi-msft]

Hi @nmccool，

You should select all the corresponding columns(to the columns from your word template) from the dynamic content.

In addition, please do show me your detailed flow configuration not the whole configuration.

[nmccool]

It is selected the way its named in the Word template, including repeating columns

 

[nmccool]

Can anyone help me?  I CANNOT get all the lines updated from Power Apps to SharePoint and then to get on my Word Template.  I ONLY get the last item entered into Power Apps form 😞

[jdoss]

I would lose the repeater and just make it a text control (make sure to allow carriage returns in the properties), then change your variable "Daily Report" to a string variable and change the "append to array variable" action to append to string variable and format it as you want it to display in the word document. 

[nmccool]

followed your directions; took out repeater out of word, changed variable to a string and removed append to array and replaced with append to string. But still same results; 3 emails with each line entered into Power App and overall details in 3 different email attachments 

[nmccool]

@jdoss 

followed your directions; took out repeater out of word, changed variable to a string and removed append to array and replaced with append to string. But still same results; 3 emails with each line entered into Power App and overall details in 3 different email attachments 

[jdoss]

Do you have some Apply to Each listed. That's the only way I can make sense of why it's sending multiple emails. If you're using information from the "Get Items" action that is listed in the first post then it may have created one automatically, if that is the case, that is where you can build your string variables and add them to the template. If there is not an Apply to each you should expand all of your actions in the flow run review and see if there is anything that could cause that.

[nmccool]

@jdoss could it be an issue in my Power App, thats where the info comes from to get into SharePoint?

[jdoss · Accepted solution]

@nmccool I think it all makes sense now. If your Power App is creating the items, each item it creates is triggering the flow. So, each line/list item then runs the flow. And that is why you were getting multiple emails. You probably want to set this up to trigger some other way, possibly at a set time/schedule. But that depends on how this is supposed to be sent. If it needs to be live, I might suggest creating another list as an email log, once you add the data for the email to sharepoint, then update the new list with an email log (just one time though not with each addition to the sharepoint) then use that to trigger your flow, gather all the data from the list with the data and send the email.