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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Generating a human-rea...
Power Automate
Unanswered

Generating a human-readable index file from SharePoint

(0) ShareShare
ReportReport
Posted on by 1,934 Moderator
Is it possible to generate an index of the content in a SharePoint site/library that is human-readable like a flat file? 
 
Thanks,
Anne
Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,073 on at

    Could you provide an example?

  • annetoal Profile Picture
    1,934 Moderator on at

    I'm looking for something like the index at the end of a book, or perhaps information that could be edited into a usable table of contents.

     

    Anne

  • VictorIvanidze Profile Picture
    13,073 on at

    Try to create a sample.

  • annetoal Profile Picture
    1,934 Moderator on at

    Here's a sample index page:

    annetoal_0-1658334480754.png

     Here is a sample table of contents

    annetoal_1-1658334559346.png

    You see that in both cases, the most important keywords are listed in human-readable form. SharePoint produces indices for its search engine, but that information is not accessible without going through the search process. I'm looking for a way to get at the contents of the index and then produce a human-readable index.
    Alternatively, if you're aware of any other way to index the contents of a library, please share!

     

    Anne

  • VictorIvanidze Profile Picture
    13,073 on at

    I know how looks an index of a book. 

     

    Let's suppose you have 10 files in Sharepoint:

    0000001.doc

    0000002.doc

    ...

    0000010.doc

     

    How the index of these files could look like in your opinion?

  • Verified answer
    David- Profile Picture
    1,254 on at

    The following may work for you:

    David_0-1658341077214.png

    Use this formula in the compose action or the links will not come out properly in the generated e-mail:

     

    replace(replace(replace(body('Create_HTML_table'), '&lt;', '<'), '&gt;', '>'), '&quot;', '"')

     

    The result of which will produced (filenames blacked out for obvious reasons):

    David_1-1658341182180.png

    You can choose whatever fields you want to display in your select statement. If you have a large document library, this will not work as the table will get cut off in Outlook. 

     

    You set up your E-mail in HTML mode as follows with the output from the compose action:

    David_2-1658341365598.png

    The style formatting is from Power Automate HTML Table Styling and Formatting (tachytelic.net)

    Maybe your or someone else will have an idea to get it to closer to what you want.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard