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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / http request to sharep...
Power Automate - Building Flows
Answered

http request to sharepoint search

(0) ShareShare
ReportReport
Posted on by nick9one1 288

Hi

 

I have a site collection 'intranet' with department sub-sites. The departments regularly post news and it is displayed in the News webpart on the front intranet page. 

We have a requirement to display the newest 10 articles on a large TV's in communal areas. 
I would like to query SharePoint for the latest news articles using power automate. The URL's for the 10 articles would be written to a file. 
Then outside of flow I will have a basic html page cycle through the 10 URL's. 

I's struggling to limit the GET request to only 10 items sorted by created date.

Can anyone help?

 

_api/search/query?querytext='IsDocument:True AND FileExtension:aspx AND PromotedState:2'

 

 

Untitled.png

 

I have the same question (0)
  • Verified answer
    sudharsan1985 Profile Picture
    sudharsan1985 1,325 on at
    Re: http request to sharepoint search

    Hi @nick9one1 

    Try to add the param like the below query

    https://tenantName.sharepoint.com/search/_api/search/query?querytext='IsDocument:True AND FileExtension:aspx AND PromotedState:2'&rowlimit=10

    Please try the above.

     

    Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
    -Sudharsan K...

  • nick9one1 Profile Picture
    nick9one1 288 on at
    Re: http request to sharepoint search

    thank you. 

    I also found this tool very useful

    https://github.com/pnp/PnP-Tools/tree/master/Solutions/SharePoint.Search.QueryTool

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans