web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create formatted text ...
Power Automate
Answered

Create formatted text file from SharePoint List

(0) ShareShare
ReportReport
Posted on by 41

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 TITLETIMELINENOTES
The Best ComputerCompletedNot a great computer
Another DayWork in ProgressComing 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:
  • Verified answer
    v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @jdeitell ,

     

    Edit

    Please try this

    vxiaochenmsft_0-1693535496130.png

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

     

    vxiaochenmsft_2-1693535837490.png

    vxiaochenmsft_3-1693535848267.png

     

    Best Regards,

    Wearsky

  • jdeitell Profile Picture
    41 on at

    This is perfect! Thank you so much for your help

  • jdeitell Profile Picture
    41 on at

    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? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard