cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amilah
Regular Visitor

Flow to export SharePoint list items into a Word Document while concatenating values in one field separated by space or symbol

Hello experts,

 

I'm trying to create a scheduled flow to export items from my SharePoint list into a Word document. So far I am able to replace values in a word document template on a row/record basis however I want to export field items filtered based on a date field in one spot like a paragraph or bulleted items list kind of thing to generate a weekly report. 

 

fields similar to: Activity, Date created, Created by, Status

 

I read something about composing but I'm not quite sure how I can apply it here. Can someone please list out the steps for the flow that I should build?

 

Any help would be hugely appreciated!

1 REPLY 1
Amilah
Regular Visitor

I researched a lot to find the best way to do this flow and here is what I found (in case this helps someone else stuck like me).

 

First of all, I am not an expert so experts feel free to jump in if I am incorrect 😊

 

I learned that it is currently not possible to export rows of SP list into a single word document by category. The best I could do came out with Html tags enclosing each value.

But you can export values into a word template that replaces placeholders like mail merge. You can use repeating section content control to create a table format. I found that I couldn’t export rows of records to the same document. Instead, this feature is quite useful to create invoice and hire letters and such documents with few values to be changed for each iteration. You do need a premium Power Automate subscription to be able to export to MS Word.

 

Here is my work around flow

  1. Trigger/recurrence
  2. Get items filtered by category and period
  3. Select – to map items
  4. Create HTML table
  5. Repeat steps 2 – 4 for each category ( I have 6)
  6. Create file that connects to all 6 tables created above and insert the values from each table into content

This is not the word document that I wanted but it contains all the essential information I needed for the report.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,019)