Create an Excel List of SharePoint File Links with Power Automate
Question details
Create an Excel list of SharePoint file names and individual sharing links using Power Automate.

- Product
- Microsoft Power Automate, SharePoint, and Excel
- Device & OS
- not provided
- Scenario
- Organization members need links to individual files without receiving access to the entire SharePoint folder.
- Observed behavior
- The desired result is an Excel table containing file names and links that eligible organization members can use to access each file.
Confirm that you can access the SharePoint library and create sharing links for its files. Create an Excel workbook in SharePoint or OneDrive with a table containing columns for file names and links.
Create individual sharing links and add them to an Excel table
Use a Power Automate flow to list files, create a link for each file, and write the results to Excel.
An organization-scoped link can give eligible people in your organization access to the linked file without sharing the entire folder. Available link types and scopes depend on your organization's sharing policies.
In Power Automate, select Create and choose a flow type, such as an instant cloud flow, with a trigger that suits when you want to build the list.
Add the SharePoint action Get files (properties only). Select the site and document library, and use the folder options if you want to limit the results to a particular folder.
Add an Apply to each action using the file results. Inside it, add SharePoint's Create sharing link for a file or folder action, select the site and library, and use the current file's ID. Choose View or Edit and the organization scope if available.
Inside the same loop, add Excel Online (Business) > Add a row into a table. Select the workbook and table, then map the current file name and the sharing link URL from the preceding action to the corresponding columns.
Save and run the flow, then open the Excel workbook and test a generated link with an eligible organization account. Confirm that the link opens the intended file and grants only the access you selected.

Review Your SharePoint Link List in WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface. Open and edit compatible Excel workbooks in WPS Spreadsheet for an easy transition, while using Microsoft Power Automate and SharePoint to create the sharing links.

Frequently Asked Questions
Does an organization sharing link give access to the whole folder?
A link created for an individual file is intended to provide access to that file, not the entire folder. Check the link scope and the site's existing permissions before sharing it.
Why can't I select the organization link scope?
Your organization's SharePoint sharing policies may restrict available link scopes. Contact your SharePoint administrator to check which options are allowed for the site.
Why doesn't my Excel table appear in Power Automate?
Open the workbook in Excel and make sure the data range is formatted as a table. Save the workbook in a supported SharePoint or OneDrive location, then select it again in the Add a row into a table action.
Can I make the file links view-only?
Yes, if your organization's policy allows it. In the Create sharing link for a file or folder action, choose View as the link type before running the flow.




