Forum Discussion
Query PWA Tasks with Enterprise Custom Field eq Yes
- Apr 13, 2020
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
- Matt GriffinApr 13, 2020Copper ContributorAre there any examples or documentation online for the SharePoint HTTP Action for querying OData API?
- Paul_MatherApr 13, 2020MVP
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