Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

URL Concatenate

Hi, i am trying to add a url to a table. I am using the follosing code (xxx is redacted)   myLink = "https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?ID=" & ('TABLE1'[Id]) howeve...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

    my url = CONCATENATE("https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?ID= ",MAX('Table'[Column1]))

    Don't use Sharepoint, but I did this as a measure, using the two parts separated by a comma and had this for a result in a card. If you put it in a column, you will probably be able to remove the MAX.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous ,

my url = CONCATENATE("https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?ID= ",MAX('Table'[Column1]))

Don't use Sharepoint, but I did this as a measure, using the two parts separated by a comma and had this for a result in a card. If you put it in a column, you will probably be able to remove the MAX.


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel