Forum Discussion
Solved
How to trigger a flow when a specific custom filed data is added or changed in project online?
ex: In Power automate the flow will run based on this trigger ,when a project is published. I had a custom filed Project Level Entity, custom filed name is Quantity that is tagged in a project det...
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
Whatever you said is correct 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
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