Forum Discussion
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...
Ximo can you not use the _api/ProjectData API to get the multiline field as this API as the HTML stripped our already?
Paul
Hello Ximo ,
I've not tried it but could this action help remove the HTML tags: Content Conversion - Connectors | Microsoft Docs
Paul
Thanks Paul_Mather, the description of the task arrives without the link in the task list, so Power Automate cannot retrieve it
using html to text with Content Conversion. If we use the single line text custom field all is ok, but trimmered if too long (more than 255 chars)
I am going to try changing the description format to text and see how it goes.
Ximo
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.
Ximo can you not use the _api/ProjectData API to get the multiline field as this API as the HTML stripped our already?
Paul
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!