Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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?

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics