'%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 Export Project Task Attachment Links to Excel
Question details
The user needs to export task attachment links from Project for the web into an Excel spreadsheet, as the standard export feature does not include these URLs.
- Product
- Microsoft Project / Excel
- Device & OS
- not provided
- Scenario
- Generating a comprehensive Excel report that includes the exact attachment links assigned to tasks within a project.
- Observed behavior
- The built-in 'Export to Excel' function in Project for the web omits attachment links, unlike the direct extraction available for Microsoft Planner.
Ensure you have access to Microsoft Power Automate and possess the necessary premium licensing to utilize the Microsoft Dataverse connector.
Extract Project Links to Excel via Power Automate
Because Project for the web stores its data in Microsoft Dataverse, you can use a Power Automate flow to retrieve the task records and append the attachment links into an Excel file.
The native Export to Excel feature limits the fields it outputs for simplicity. To retrieve complex relational data such as task attachments, you must query the underlying Dataverse database directly using Power Automate.
Open Power Automate, click on 'Create' from the left sidebar, and select 'Instant cloud flow' or 'Automated cloud flow' based on your preference.
Add a new step, search for 'Microsoft Dataverse', and select the 'List Rows' action. This connector is required to access Project for the web data.
Configure the 'List Rows' action to target your specific project tasks by applying an OData filter query using your Project ID.
Add an 'Apply to each' loop to iterate through the retrieved rows. Inside the loop, collect each task ID and its corresponding link URI to build an array of attachment links.
Add the 'Excel Online (Business)' connector and choose the 'Add a row into a table' action. Map your collected task names and attachment links to the columns in your target Excel file.
View and Edit Your Exported Data with WPS Office
After successfully exporting your project task links, use WPS Office as a highly compatible, lightweight, and free alternative to Microsoft Office. It offers a familiar interface and robust tools for formatting and analyzing your newly created Excel spreadsheets.
- 1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
- 2. Open Your Exported File: Launch WPS Spreadsheet and open the .xlsx file you populated via Power Automate.
- 3. Manage Your Data: Use built-in formatting, filtering, and data analysis tools to easily manage and review your extracted task links.
Frequently Asked Questions
Why doesn't the default Export to Excel include task attachments?
The default export feature in Project for the web is designed for basic task metadata, such as names, start dates, and end dates. Complex relational data like file attachments and external links are stored separately in Dataverse and require custom extraction workflows.
Do I need a premium license to use the Dataverse connector in Power Automate?
Yes, Microsoft Dataverse is categorized as a premium connector in Power Automate. You will need an appropriate premium license to create and run flows that interact directly with Dataverse rows.
Can I use this same method to export Planner task links?
While you can use Power Automate to export Planner tasks, you do not need the premium Dataverse connector. Microsoft Planner has its own standard connector in Power Automate that allows you to directly list tasks and extract their details.
