Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Get automatic url listing in a share Point list

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's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator
      2 years ago

      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.