Format of text fields when using OData and Excel Query RRS feed

  • Question

  • Hi guys

    I'm working with a report where I import custom multiple line text fields from Project Online to Excel 2016 through an OData feed. When I import the text fields this way, they do not keep their source formatting, so line breaks or bullet points are removed and the text is just imported as full run on text. I have tried to transform the text in the Query editor, but I have not found a way to make the Query import the fields with the source format. When I import custom text fields from lists in my PWA, they keep their source formatting, so my question is: Is there a way to keep the source format for custom text fields from Project Online when importing to Excel reports? Or is the format of the custom fields different in way that makes import of source format impossible?

    Tuesday, May 2, 2017 11:50 AM


All replies