Create formatted text file from SharePoint List

(0) Share

Report

Posted on by jdeitell

Hey all, I have a SharePoint List from which I am looking to make a text report.

Essentially, the data input looks something like this (but with 12 columns, and about 100 rows):

PROJECT TITLE	TIMELINE	NOTES
The Best Computer	Completed	Not a great computer
Another Day	Work in Progress	Coming along great

And I would like the output to look something like this (either in Word or PDF):

PROJECT TITLE: The Best Computer

TIMELINE: Completed

NOTES: Not a great computer

PROJECT TITLE: Another Day

TIMELINE: Work in Progress

Notes: Coming along great

I have been able to accomplish this for a single SharePoint list item using Get item -> Compose (with some basic html formatting) but I can't figure out how to make this function apply to each row/item in the SharePoint list, except by using the html table function. And if I use an html table, I can't seem to figure out how to format that data back into plain text either.

Any input on simplest approach would be greatly appreciated. Thanks!

Best,

Josh

Categories:

Business Process Flows

All responses (3)

Answers (1)

jdeitell 41 on at

Like (0)

Report

Re: Create formatted text file from SharePoint List

Have a follow-up question if it's not too much trouble. When I run this script it's displaying the items in order of date created. Right now my SharePoint list is sorted by a column called PRIORITY and then a column called TITLE. How can I apply the same sorting to this Flow output?
jdeitell 41 on at

Like (0)

Report

Re: Create formatted text file from SharePoint List

This is perfect! Thank you so much for your help
Verified answer

v-xiaochen-msft on at

Like (2)

Report

Re: Create formatted text file from SharePoint List

Hi @jdeitell ,

Edit

Please try this

PROJECT TITLE: @{items('Apply_to_each')?['Title']}<br>TIMELINE: @{items('Apply_to_each')?['TIMELINE']}<br>NOTES: @{items('Apply_to_each')?['NOTES']}<br><br>

Best Regards,

Wearsky