Forum Discussion

nok's avatar
nok
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Get attachment link from SP List Attachment column

Hello!

I have a SharePoint list that has files attached in the Attachments column.


I want to create a visual table in my Power BI that shows the attachment link for each item in this list, so that the user can click on the link and be redirected to the file if they want to download it. How can I get the attachment link from a SharePoint list and use it in Power BI?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi nok , hello MattiaFratello, thank you for your prompt reply!

     

    Create a new blank query and paste the following M code to meet your requirement:

    let
    SharePointSiteURL = "YourSharePointSiteUrl",

    SharePointTenant="https://Yourtenantname.sharepoint.com",
    
    API_URL = SharePointSiteURL & "/_api/web/lists/getbytitle('YourListName')/items?$expand=AttachmentFiles",
    
    Source = Json.Document(Web.Contents(API_URL, [Headers=[#"Accept"="application/json;odata=nometadata"]])),
    
    ListItems = Source[value],
    
    ExpandedItems = Table.ExpandRecordColumn(Table.FromList(ListItems, Splitter.SplitByNothing()), "Column1", {"ID", "Title", "AttachmentFiles"}),
    
    ExpandedAttachments = Table.ExpandListColumn(ExpandedItems, "AttachmentFiles"),
    
    AttachmentUrls = Table.ExpandRecordColumn(ExpandedAttachments, "AttachmentFiles", {"ServerRelativeUrl"}),
    
    FinalTable = Table.AddColumn(AttachmentUrls, "AttachmentLink", each SharePointTenant & [ServerRelativeUrl], type text),

    ResultTable = Table.SelectColumns(FinalTable, {"ID", "Title", "AttachmentLink"})
    
in
    ResultTable

    Remember to cahnge the siteurl, tenantname, and listname to your specific values

    After that, format the text in the column as a web URL:

    My sample test for your reference:

    Best regards,

    Joyce

    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
    1 year ago

    Hi nok , hello MattiaFratello, thank you for your prompt reply!

     

    Create a new blank query and paste the following M code to meet your requirement:

    let
    SharePointSiteURL = "YourSharePointSiteUrl",

    SharePointTenant="https://Yourtenantname.sharepoint.com",
    
    API_URL = SharePointSiteURL & "/_api/web/lists/getbytitle('YourListName')/items?$expand=AttachmentFiles",
    
    Source = Json.Document(Web.Contents(API_URL, [Headers=[#"Accept"="application/json;odata=nometadata"]])),
    
    ListItems = Source[value],
    
    ExpandedItems = Table.ExpandRecordColumn(Table.FromList(ListItems, Splitter.SplitByNothing()), "Column1", {"ID", "Title", "AttachmentFiles"}),
    
    ExpandedAttachments = Table.ExpandListColumn(ExpandedItems, "AttachmentFiles"),
    
    AttachmentUrls = Table.ExpandRecordColumn(ExpandedAttachments, "AttachmentFiles", {"ServerRelativeUrl"}),
    
    FinalTable = Table.AddColumn(AttachmentUrls, "AttachmentLink", each SharePointTenant & [ServerRelativeUrl], type text),

    ResultTable = Table.SelectColumns(FinalTable, {"ID", "Title", "AttachmentLink"})
    
in
    ResultTable

    Remember to cahnge the siteurl, tenantname, and listname to your specific values

    After that, format the text in the column as a web URL:

    My sample test for your reference:

    Best regards,

    Joyce

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