Forum Discussion
How to trigger a flow when a specific custom filed data is added or changed in project online?
Hello Anil_kumar ,
There isn't a Power Automate flow trigger for a field change for Project Online, all you can do is fire the flow when the project is published. If you are tracking the data in an SP list, you could compare the data in the project and the latest record in the SP list to see if the field value changed or not.
Paul
Hello Anil_kumar ,
What is ReadAllProjects querying / returning? What is the Get Items querying / returning?
Power Automate will add in the Apply to each loop when the previous action returns an array of results and you are trying to use that dataset. "Get Items" assumes many items will be returned, hence the apply to each loop, where as "Get Item" will just return 1 item so no loop required. So you'd need to find the latest record for the published project from the SharePoint list, then compare that data with the live project.
Paul
1. ReadallProjects(send an http request) returning the project level custom fields data
/_api/ProjectData/Projects()?$Select=ProjectName,Quantity
Ex: It returns 10 Projects from PWA
2. GetItems action returning the sharepoint list data .
Ex: It returns 5 row items
Projects Quanity
A 10
B 20
c 10
d 5
e 7
You are suggesting to use the Get item action , but in get item action we have to mention the SharePoint id right?That id i am taking form the get items action
Eventhough when i am taking the getitem returned column, the flow is automatically adding the apply to each 2 again.
I have to explore on the logical part paul. Thanks for the suggestions
Hello Anil_kumar ,
That is correct, when using the "Get Item" action, you will need to pass in the list item ID for the project record from the SP list that you want to compare with the live project from PWA.
Paul