This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
I am using Planner premium license and created few custom fields. I wanted to get custom fields using API but Dataverse API suggested that we can not read custom fields as it is saved as Blob.
I have explored other option regarding Export to Excel but it requires manual export. So, any API support Export as Excel option?
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 37%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Samir KHIMANI,
Based on the currently documented capabilities, there is no supported public API or Power Automate action that can invoke Planner Premium's built-in Export as Excel functionality.
The Microsoft Graph Planner API v1.0 does not support Planner Premium (formerly Project for the web) plans or tasks. Standard Premium plan data can be queried from Microsoft Dataverse, but custom fields created directly in Planner Premium are not exposed as regular columns in msdyn_projecttask. Microsoft currently does not document a supported API or schema that can retrieve those custom field values and reproduce the complete Excel export.
For the time being, the available options are:
You may also consider opening a Microsoft support request to confirm whether any newer supported options are available for your specific environment.
Additionally, I would strongly recommend avoiding the use of undocumented project.microsoft.com/pss endpoints in production. Although some community discussions reference these endpoints, Microsoft does not officially document or support them, and they may change or be removed without notice, which could break automation unexpectedly.
I hope this helps clarify the current limitations and available options a bit more. If you have any updates, please feel free to leave a comment, and I'd be happy to discuss it further.
Thank you so much for taking the time.
If the answer is helpful, please kindly click "Yes" button below. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.