Custom task field that is a URL but shows a label not the full URL

[EricSa7]

Hi team,

I use Power Apps to automate many of the tasks that we have as part of our projects. To help users access the app direct from Workfront, I have created a custom calculated task field that stings together a URL that will open the app on the page needed with the project loaded. 

The issue is, the URL is long and takes up a lot of room. 

Is there a way I can have this URL behind text such as "Go To Power App". Like you would if you were doing HTML (<a href="url">Go To Power App</a>)

The calculation I am using is...

CONCAT("https://apps.powerapps.com/play/e/10ce04bd-ba11-e353-9800-82af01dab1cb/a/f31e71a2-b125-4314-bcd7-511...",{DE:SAAT Screen Code},"&PID=",{project}.{referenceNumber})

Can I display this URL on each task as  "Go To Power App"?

Thanks for your help. 

[Sri_Nijs]

You can create a custom Descriptive text field with your desired label and add the hyperlink on a custom form as below

and it would appear as a hyperlink to click on the custom form in the object details

Then, you have to add this custom form to a specific task and create a view or add on your existing views with this custom field to have simple and quick view of this URL.

[EricSa7]

Hi Sri,

Can the URL in your solution be dynamic and built from data within the system, or does it need to be hardcoded as static text? 

Cheers, 

[Rafal_Bainie]

My first question would be where you want to display this, because answer may be different.

Do you want to have this in report? in custom field in task/issue/project details page?

[EricSa7]

Hi Rafal,

I am looking to display this in the task list on a project. 

Cheers, 

[Rafal_Bainie · Accepted solution]

that will be your code:

displayname=link
link.url=customDataLabelsAsString(YOUR CALCULATED FIELD)
textmode=true
valueexpression=IF(ISBLANK({DE:YOUR CALCULATED FIELD}),"","Go To Power App")
valueformat=HTML

Calculated field is where you put your concatenation, but it seems you have this piece figured out.

you will get something like this:

hope this helps

[EricSa7]

Thanks for the extra details, but I'm not sure where your code is physically entered within Wrokfront. Any guidance would be great. 

[EricSa7]

Hi Rafal, 

I did some playing and found out how to add the code to a view. 

You are a legend. 

Thanks,