SOLVED

Query PWA Tasks with Enterprise Custom Field eq Yes

%3CLINGO-SUB%20id%3D%22lingo-sub-1296106%22%20slang%3D%22en-US%22%3EQuery%20PWA%20Tasks%20with%20Enterprise%20Custom%20Field%20eq%20Yes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296106%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20setup%20a%20Power%20Automate%20that%20will%20create%20a%20Planner%20Bucket%20when%20a%20PWA%20Project%20has%20a%20task%20created%20where%20a%20Customer%20Enterprise%20Field%20is%20set%20to%20Yes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Project%20Online%20Power%20Automate%20Action%20List%20Task%20doesn't%20return%20Enterprise%20fields.%20I%20was%20looking%20in%20the%20Common%20Data%20Service%3B%20however%20I%20am%20not%20finding%20the%20PWA%20entities%20in%20the%20Common%20Data%20Service.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20direction%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1299015%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20PWA%20Tasks%20with%20Enterprise%20Custom%20Field%20eq%20Yes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1299015%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F122048%22%20target%3D%22_blank%22%3E%40Matt%20Griffin%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EAs%20you%20have%20seen%2C%20the%20Power%20Automate%20actions%20for%20Project%20Online%20are%20not%20aware%20of%20the%20any%20Enterprise%20Custom%20fields.%20Project%20Online%20data%20is%20not%20in%20the%20CDS%20either%20as%20Project%20Online%20is%20an%20application%20built%20in%20SharePoint.%20If%20you%20want%20to%20use%20Power%20Automate%2C%20maybe%20you%20could%20have%20a%20SharePoint%20HTTP%20action%20and%20query%20the%20Project%20Online%20Reporting%20OData%20API%20to%20get%20the%20tasks%20and%20the%20Enterprise%20custom%20field%20values%20then%20use%20that%20data%20in%20the%20other%20actions.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1302367%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20PWA%20Tasks%20with%20Enterprise%20Custom%20Field%20eq%20Yes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1302367%22%20slang%3D%22en-US%22%3EAre%20there%20any%20examples%20or%20documentation%20online%20for%20the%20SharePoint%20HTTP%20Action%20for%20querying%20OData%20API%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1303448%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20PWA%20Tasks%20with%20Enterprise%20Custom%20Field%20eq%20Yes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1303448%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F122048%22%20target%3D%22_blank%22%3E%40Matt%20Griffin%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EThere%20are%20quite%20a%20few%20on%20my%20blog%20using%20the%20SharePoint%20HTTP%20Power%20Automate%20action%20for%20Project%20Online%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F%3C%2FA%3E%26nbsp%3B-%20here%20are%20some%20specific%20examples%20(there%20are%20more%20but%20these%20will%20give%20you%20the%20idea)%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2018%2F12%2F14%2Fprojectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2018%2F12%2F14%2Fprojectonline-snapshot-data-to-sharepoint-list-using-msflow-microsoftflow-ppm-pmot-office365-powerplatform%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2019%2F08%2F28%2Fprojectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-to-chase-users-for-overdue-timesheets-ppm-projectmanagement-msproject-powerplatform-office365%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2019%2F08%2F28%2Fprojectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-to-chase-users-for-overdue-timesheets-ppm-projectmanagement-msproject-powerplatform-office365%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2019%2F08%2F24%2Fprojectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-for-project-owner-actions-ppm-projectmanagement-msproject-office365-powerplatform%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2019%2F08%2F24%2Fprojectonline-and-adaptive-cards-in-microsoftteams-using-microsoftflow-for-project-owner-actions-ppm-projectmanagement-msproject-office365-powerplatform%2F%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2019%2F07%2F31%2Fprojectonline-custom-email-notifications-using-msflow-microsoftflow-ppm-pmot-msproject-exchange-office365-powerplatform-planner-part-3%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2019%2F07%2F31%2Fprojectonline-custom-email-notifications-using-msflow-microsoftflow-ppm-pmot-msproject-exchange-office365-powerplatform-planner-part-3%2F%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!

3 Replies
Highlighted

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

Highlighted
Are there any examples or documentation online for the SharePoint HTTP Action for querying OData API?