Skip to main content
March 23, 2022
Question

How to get product Hyperlinks in Excel export

  • March 23, 2022
  • 5 replies
  • 0 views

Hi Team, 

I have a database which stores document data of Appian.

The database table stores DOCUMENT ID of the product. 

it is like

TaskOwnerName        Document ID

A                                    356234

B                                    321434

C                                    413434

D                                    431431

Now I want a excel export of the above data but instead of document ID i want document hyperlink. I can do this easily on the grid. But I am unable to do that in Excel Export

Can you please help me, It is very urgent

    5 replies

    mikes0011
    Brainy
    March 23, 2022

    I don't know if there's currently any supported way of doing this, however you might have some luck with the method suggested here (if it even works, which I'm not in a position to test at the moment).  Note that the cell value would just need to be the entire URL, i believe, as I don't think there's a way to turn a cell into a hyperlink (at least without some sort of super complicated workaround).

    The Expression Guru
    peter.lewis
    Participating Frequently
    March 23, 2022

    There's actually an easier way to get the link to the document now too - you can just use the document() function and use the "url" property like this:

    document(123, "url")

    mikes0011
    Brainy
    March 23, 2022

    ooh, nice, i must've missed that one.

    The Expression Guru