web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate http request to sharep...

Power Automate

Answered

http request to sharepoint search

(0) Share

Report

Report

Posted on by nick9one1

353

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'

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

sudharsan1985 1,325 on at

Like
a
(0)

Report
Copy link

Link copied!
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 353 on at

Like
a
(1)

Report
Copy link

Link copied!

thank you.

I also found this tool very useful

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

Join the conversation