none
Powershell script to export Sharepoint list hyperlink column to excel? RRS feed

  • Question

  • Hi All,

    I want a SharePoint list "Document id" column (which has a link to open a document) to be exported to excel using powershell script.

    I can able export the item values, but it is displaying with url and description as below in the excel cell.

     https://test.com/sites/1/_layouts/15/DocIdRedir.aspx?ID=EA1-12345, EA1-12345

    Can it be EA1-12345 value with a hyperlink and when user clicks it opens up the url as above.

    I tried getting the url and description separately from share point list field and used html to create a link, but none worked.

    Please help me out on this.

    Thanks

    Friday, February 24, 2017 11:35 AM