Forum Discussion

Ximo's avatar
Ximo
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's avatar
    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's avatar
Ximo
Brass Contributor
Apr 21, 2022

Hi Paul_Mather, totally agree, the problem with the simple text field is that the URL length is trimmed when the project name is long, because of that we wanted to check with Multiple lines of text custom field.
On top of that, we are using the modern SharePoint sites and the Copy Link feature does not shorten the URL either...

Paul_Mather's avatar
Paul_Mather
MVP
Apr 21, 2022

Hello Ximo ,

Those fields John mentioned are MS Project fields, these are no in PWA. Could you just put a URL into the document library as that URL is possibly shorter?

Paul

  • Ximo's avatar
    Ximo
    Brass Contributor
    Apr 21, 2022

    Hi Paul_Mather, we use the "document link" Project custom field in the PDP to compose the approval task via SP2013 PWA Workflow (managing the stages) in a list. The value has been manually copied from the Project Documents library and pasted in the PDP. 

     

    When the SP2013 PWA Workflow creates the task in the list, Power Automate sends an email with a link to the specific document under approval and the approve/reject buttons. This way they do not need to access the list of tasks and is easier to approve the document.

     

     

    Once the user clicks the approve/reject buttons in the Power Automate generated email, the same Power Automate updates the task with the outcome. 

     

    A link to the document library as that URL would force the approver to find out what document in the library is the one we are approving, while a link to the specific document is directly opening in the email.

    Ximo

     

      • Ximo's avatar
        Ximo
        Brass Contributor
        Apr 21, 2022

        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

         

         

Resources