Get automatic url listing in a share Point list

[Syndicate_Admin]

Hello

In my report I have added a table with project issues. The data source comes from a Share Point list where each row is an issue. I have 100 rows so I have 100 incidents each with its ID.

I would like to get a list of urls from the Share Point to then link it in the report and that every time we click on a link in the report it takes us directly to the content of the incident in each row.

Reviewing previous posts there is one that comes close to what I need and that works perfectly for me, which is to concatenate the general address with the ID of the incident: https:// your tenant/sites/SiteName/Lists/ListName/DispForm.aspx?ID=1

The original answer is this: SharePoint List Item URL - Microsoft Fabric Community

This is a solution.

The question I have is, is it really not possible to get a download directly from the complete list?

It seems very strange to me because if you do it individually, that is, you enter Share Point row by row to the content, a Copy link appears, copying that specific url address for that incident. I put it in the image. I find it strange that you can't download all the incidents on the list at once. It's possible? Thanks a lot. Best regards.

[Anonymous · Accepted solution]

Hi, @Syndicate_Admin 

Yes, to connect to SharePoint Online using PowerShell and perform related actions, you need to install some specific modules. Below are the modules you need to install and how to install them:

Installing the PnP PowerShell Module
The PnP PowerShell module is a powerful tool that can help you manage SharePoint Online.Here are the installation steps:
1. Open PowerShell: Run PowerShell as administrator.
2. Install the PnP PowerShell module:

Install-Module -Name PnP.PowerShell -AllowClobber -Force

1. Introduction of modules:

Import-Module PnP.PowerShell

Connecting to SharePoint Online
After installing and importing the module, you can connect to SharePoint Online using the following commands:

Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/SiteName" -UseWebLogin

Use this command below to get the Sharepoint list:

$items = Get-PnPListItem -List "ListName"

Use the following command to generate a list of URLs:

foreach ($item in $items) {
    $url = "https://yourtenant.sharepoint.com/sites/SiteName/Lists/ListName/DispForm.aspx?ID=" + $item.Id
    Write-Output $url
}

You need to have an in-depth knowledge of the Power shell before practicing this method, and you will be able to get this list automatically.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Hello

I appreciate your help very much but I think this is a bit big for me...

At least now I know that there is a way to download the entire table at once. Honestly, I'm going for the post that he generated previously and that is going to be easier.

Thank you very much for your help as well.

Best regards.