Forum Discussion
Query PWA Tasks with Enterprise Custom Field eq Yes
I am trying to setup a Power Automate that will create a Planner Bucket when a PWA Project has a task created where a Customer Enterprise Field is set to Yes.
The Project Online Power Automate Action List Task doesn't return Enterprise fields. I was looking in the Common Data Service; however I am not finding the PWA entities in the Common Data Service.
Any direction is appreciated!
Hello Matt Griffin,
There are quite a few on my blog using the SharePoint HTTP Power Automate action for Project Online: https://pwmather.wordpress.com/ - here are some specific examples (there are more but these will give you the idea):
- https://pwmather.wordpress.com/2018/12/14/projectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform/
- https://pwmather.wordpress.com/2019/08/28/projectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-to-chase-users-for-overdue-timesheets-ppm-projectmanagement-msproject-powerplatform-office365/
- https://pwmather.wordpress.com/2019/08/24/projectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-for-project-owner-actions-ppm-projectmanagement-msproject-office365-powerplatform/
- https://pwmather.wordpress.com/2019/07/31/projectonline-custom-email-notifications-using-msflow-microsoftflow-ppm-pmot-msproject-exchange-office365-powerplatform-planner-part-3/
Paul
Hello Matt Griffin ,
As you have seen, the Power Automate actions for Project Online are not aware of the any Enterprise Custom fields. Project Online data is not in the CDS either as Project Online is an application built in SharePoint. If you want to use Power Automate, maybe you could have a SharePoint HTTP action and query the Project Online Reporting OData API to get the tasks and the Enterprise custom field values then use that data in the other actions.
Paul
- Are there any examples or documentation online for the SharePoint HTTP Action for querying OData API?
Hello Matt Griffin,
There are quite a few on my blog using the SharePoint HTTP Power Automate action for Project Online: https://pwmather.wordpress.com/ - here are some specific examples (there are more but these will give you the idea):
- https://pwmather.wordpress.com/2018/12/14/projectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform/
- https://pwmather.wordpress.com/2019/08/28/projectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-to-chase-users-for-overdue-timesheets-ppm-projectmanagement-msproject-powerplatform-office365/
- https://pwmather.wordpress.com/2019/08/24/projectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-for-project-owner-actions-ppm-projectmanagement-msproject-office365-powerplatform/
- https://pwmather.wordpress.com/2019/07/31/projectonline-custom-email-notifications-using-msflow-microsoftflow-ppm-pmot-msproject-exchange-office365-powerplatform-planner-part-3/
Paul
