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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Gallery / Power Apps - Webinars and Video Gallery / 🔎 Search File Content 📃 i...

🔎 Search File Content 📃 in Power Apps from SharePoint Document Libraries

Views (904)
RezaDorrani Profile Picture Posted by RezaDorrani 12,145

In this Power Apps Tutorial Video, I demonstrate how to seamlessly search within files from SharePoint Document Libraries in Power Apps, utilizing the combined powers of Power Automate and the SharePoint Search REST API endpoint.

 

Throughout this PowerApps tutorial, you'll gain valuable insights into leveraging the SharePoint Search REST API to enable Power Apps to search document libraries effectively. This PowerApps video offers a step-by-step walk through of building the search experience, including making REST API calls to the SharePoint Search REST API via Power Automate flows, parsing search JSON results, presenting data in a Gallery, implementing pagination for search results, searching across multiple Document Libraries and much more.

 

Key topics covered in this video include:
✅ Demo - Power Apps Search within file Content and Metadata for multiple SharePoint Document Libraries
✅ SharePoint Search REST API walkthrough
✅ Power Apps call flow to query SharePoint Search REST API
✅ ParseJSON in Power Apps to showcase search results in a Gallery


Thanks,
Reza Dorrani, MVP
YouTube
Twitter

 

Categories:

 Canvas Apps General PowerApps

Comments

  • 0Fadi0 Profile Picture 0Fadi0 2
    Posted at
    ?? Search File Content ?? in Power Apps from SharePoint Document Libraries

    @Alex-W  Thanks for posting. I've been trying to do something similar. Just a question, what did you add in the "Respond to PowerApp or Flow" to pass the column value back to the PowerApp? Thank you.

  • Alex-W Profile Picture Alex-W 327
    Posted at
    ?? Search File Content ?? in Power Apps from SharePoint Document Libraries

    @RezaDorrani Awesome tutorial! It worked great, but I had an additional requirement to target a metadata column so that the search results did not show results for the entire library.  It took me a few days to figure it out, but I got it to work.  My experience level is nowhere close to yours.  So, I would like to see if you could check my work to see if you would do it a simpler way.

    This is my setup:

     

    1. Go to the library's advanced settings and click Yes for Index Non-Default Views then clicked the Reindex Document Library button (this update took about an hour)

    2. Go the search schema settings on SharePoint

    3. Select one of the RefinableString managed property under Managed Properties (I selected RefinableString00)

    4. Scroll down to the bottom of the RefinableString00 settings page and click on "Add a mapping" to the "Mappings to crawled properties"

    5. Search for the column that contains the metadata that will be filtered.  For my requirement, this the category column and when I searched for it, I saw a crawled property for ows_Category that I selected.

    6. On the HTTP request on Power Automate, I updated the Uri with the following after the path string:

     

    &selectedproperties='RefinableString00'&refinementfilters='RefinableString00:equals("CategoryName")'

     

     

    I ran a few tests with this setup and all results are positive so far.