URL Concatenate

[Anonymous]

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])

however, this just returns 'TABLE1'[Id]. The first element of the above code is highlighted in red and not returned. No errors highlighted. 

Any ideas?

[Nathaniel_C · Accepted solution]

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