'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Access Project Online Custom Fields and WBS in Power Apps
Question details
The user needs to retrieve and display Project Online Custom Enterprise Fields and WBS data within a Power Apps gallery.
- Product
- Power Apps / Project Online
- Device & OS
- not provided
- Scenario
- Building an application in Power Apps and attempting to use the ProjectOnline.ListTasks connector to pull custom fields from Project Web App (PWA).
- Observed behavior
- Fields such as WBS and custom enterprise fields are not accessible or visible in the gallery when using the standard ProjectOnline.ListTasks connector.
Ensure your custom enterprise fields are correctly published in the Project Web App (PWA) environment and verify your Power Apps connection credentials before troubleshooting API limitations.
Consult the Power Platform Community for Connector Alternatives
Because the standard ProjectOnline.ListTasks connector has limitations regarding custom enterprise fields and WBS, consulting specialists in the Microsoft community is the best way to find alternative APIs or custom connector solutions.
The out-of-the-box Project Online connector for Power Apps does not expose all custom enterprise fields or specific structural fields like WBS. Resolving this typically requires leveraging the Project Online REST API via Power Automate or creating a Custom Connector.
Make a comprehensive list of the specific WBS and custom enterprise fields you are trying to query from your Project Web App.
Navigate to the official Microsoft Power Platform Community forums where API and connector experts provide tailored workarounds.
Post your specific scenario on the forum (e.g., https://community.powerplatform.com/forums/) asking for guidance on alternative APIs, HTTP request configurations, or custom connectors to retrieve your PWA data.
Manage Project Data Effectively with WPS Office
While resolving complex Power Apps connector limitations requires technical API configurations, you can easily handle everyday project tracking, task lists, and WBS documentation using WPS Office. It is a highly compatible, free alternative to Microsoft Office that simplifies your workflow.
- 1. Download WPS Office: Visit the official WPS website and download the free office suite to your device.
- 2. Create a Project Tracker: Open WPS Spreadsheet and use built-in templates to create a Work Breakdown Structure (WBS) or task list.
- 3. Save as Excel Format: Save your document as an .xlsx file to ensure seamless sharing with team members using Microsoft Office.
Frequently Asked Questions
Can the ProjectOnline.ListTasks connector retrieve custom enterprise fields by default?
No, the standard ProjectOnline.ListTasks connector in Power Apps typically only exposes default task fields. Retrieving custom enterprise fields usually requires utilizing the Project Online REST API directly.
How do I access the Project Online REST API for Power Apps?
You can access the REST API by either creating a Custom Connector in Power Apps or by using Power Automate to send HTTP requests to the Project Web App (PWA) OData endpoints to fetch the required custom data.
Why is my WBS field missing from the Power Apps gallery?
Standard connectors often omit complex data types or specific structural fields like WBS to maintain optimal performance. You will need to query the PWA data feed through a custom API integration to surface this information in your gallery.
