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:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (2)

Report

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

Was this reply helpful? Yes No
jdeitell 41 on at

Like (0)

Report

This is perfect! Thank you so much for your help

Was this reply helpful? Yes No
jdeitell 41 on at

Like (0)

Report

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?

Was this reply helpful? Yes No