File Sharing Problems

Create an Excel List of SharePoint File Links with Power Automate

Algirdas JasaitisAlgirdas Jasaitis Nov 14, 2026 868 views

Question details

Create an Excel list of SharePoint file names and individual sharing links using Power Automate.

Create an Excel List of SharePoint File Links with 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a flow

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.

2
Get the SharePoint files

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.

3
Create a link for each file

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.

4
Add the results to Excel

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.

5
Test the list

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.

Create individual sharing links and add them to an Excel table
Check your sharing policy: If the organization link scope is unavailable, contact your SharePoint administrator. An organization link may be usable by eligible people across the organization who have the link, so use it only if that audience is appropriate.
Free Microsoft Office alternative

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.

Review and organize file names and URLs in WPS Spreadsheet.Open and edit Microsoft Excel XLSX workbooks.Use a familiar spreadsheet interface for an easier transition from Office.Work with a free, lightweight office suite.
microsoft office alternative - wps office

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.