'%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 Find Project for the Web Custom Fields in Dataverse
Question details
The user needs to locate custom fields created within the Project for the Web Tasks grid, which are stored in Dataverse but hidden from the default table list.
- Product
- Microsoft Project for the Web
- Device & OS
- not provided
- Scenario
- A user creates a custom field in the Project for the Web Tasks grid and needs to access it in the backend Dataverse database for reporting or integration purposes.
- Observed behavior
- The custom field is successfully created in Project for the Web, but the corresponding table and field do not appear in the default Dataverse table view in Power Apps.
Ensure that you have the necessary System Administrator or System Customizer roles in Power Apps to view all tables and solutions within your Dataverse environment.
Locate Custom Fields Using the Power Apps Table Filter
Change the default view settings in the Power Apps Maker portal to reveal all tables, including the specific ones used by the Project Power App.
Project for the Web stores its data, including custom fields, in standard Dataverse tables. However, to keep the interface clean, Power Apps hides many of these tables by default. You need to adjust your view settings to access them.
Navigate to the Power Apps maker portal (make.powerapps.com) and ensure you are logged into the correct default environment where Project is deployed.
On the left-hand navigation pane, select Dataverse (if expanded) and click on Tables.
In the top right corner of the Tables list, click on the Default filter dropdown and change it to All to reveal hidden and system tables.
Use the search bar in the upper right to look for tables starting with 'Project' or the prefix 'msdyn_project' (such as Project Task).
Click on the appropriate Project table, open the Columns tab, and browse or search for the custom field you created in the Tasks grid.
Manage Your Projects Efficiently with WPS Office
While enterprise tools like Project for the Web rely on complex Dataverse backends, WPS Office provides a lightweight, entirely free alternative for everyday project tracking. You can easily plan tasks, assign resources, and create Gantt charts using familiar spreadsheet functionalities without navigating complex database settings.
- 1. Download WPS Office: Visit the official WPS website to download and install the free software on your device.
- 2. Open a Spreadsheet Template: Launch WPS Spreadsheet, navigate to the Template library, and search for 'Project Plan'.
- 3. Track Your Tasks: Enter your task data, customize your columns immediately, and save your file in .xlsx format for maximum compatibility.
Frequently Asked Questions
Why are my Project for the Web custom fields not visible in Power Apps by default?
Power Apps applies a default filter to the Tables view to only show standard, commonly used tables. Because Project for the Web relies on specific backend tables (often prefixed with 'msdyn_'), you must switch your view filter from 'Default' to 'All' to see them.
Which specific Dataverse table holds the Project for the Web tasks?
Tasks created in Project for the Web are typically stored in the 'Project Task' table. Its logical name in the Dataverse database is usually 'msdyn_projecttask'.
Can I view Project custom fields in the Power Apps admin center?
The Power Apps admin center is used to identify and manage environments, including finding your default Dataverse environment. However, to actually view the tables and custom fields, you must use the Power Apps Maker portal (make.powerapps.com).
