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 / How to get list of pro...
Power Automate
Unanswered

How to get list of projects (Project Online) with applying filter on workflow state or status

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Team,

 

I would like to get a List of Projects from Project Online by applying a filter.

 

For example

1. I can`t loop more than 300 projects.

If the flow can get more than 300 projects then apply a filter on projects to get an only the required project 

so here filter on the Workflow stage 

1. we have 10k records(nodes) from Project online, here I would like to get only 5k records instead of getting all the records.

I tried with the below API, i am getting all the projects, here I can`t apply the filter

_api/projectdata/Projects

 

Applied filter here like this 

_api/ProjectServer/Projects?$select=SiteName&$filter=WorkflowStage eq 'Completed'

 

muralikrishna12_0-1651688597942.png

 

any help please to get sort out 1 and 2 issues here?

Categories:
I have the same question (0)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard