Forum Discussion

Brass Contributor

Apr 21, 2022

Solved

Multiple lines of text Custom Field in Project Online

Hi all, I am trying to use a Custom Field based on Multiple lines of text to store a link. The problem is that these Multiple lines CFs are adding extra html characters: <p>https://xxx.sharepo...

Paul_Mather
Apr 21, 2022
Ximo can you not use the _api/ProjectData API to get the multiline field as this API as the HTML stripped our already?

Paul

Ximo

Brass Contributor

Apr 21, 2022

Changing the description format did not work, the link is only properly populated when the custom field is a single line of text, it is a pity that modern SPO sites still does not have short urls when copying a link to a document.

I have tried as well to remove the html tags and characters in SP Designer, in the workflow itself, but no luck. We may start considering returning to classic SPO sites where using the Get a link feature (View link) the link is always short, no matter the length of the filename/project name.

Paul_Mather

MVP

Apr 21, 2022

Ximo can you not use the _api/ProjectData API to get the multiline field as this API as the HTML stripped our already?

Paul

Ximo
Brass Contributor
Apr 21, 2022
Hi Paul_Mather, that sounds good! Updating the Power Automate actions to get the Project Name and the Document type under approval to call the _api/ProjectData API to retrieve the related CF. Maybe with some string manipulation in a Compose action would make the trick as well.

Thank you!