cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Get XML As Plain Text in Email / Column

Jump to solution

Hey folks!

I'll admit - I don't use O365 very much. And, due to this fact, I struggle with some things that are fairly basic.

Example (and the topic of this post): 

We're using the O365 Search Query to retrieve some data on a Content Type. Neat. We're returning the source as XML. Also neat. HOWEVER! We need to be able to view the XML brought back with all of its tags in tact, and it keeps rendering them and thus disappearing. Here is what we have tried:

- Emailing it to ourselves using the Advanced Lookup to select Workflow Variable, txtXML, and selecting the format as Plain Text

- Writing it to a multi-line SharePoint column set to Plain Text

- Wrapping with the tags XMP

- Sacrificing a keyboard to the gods of XML

What's interesting is that, if we Log To History, all is well - XML, ahoy.

Can you help us out?

CC Amy Grendus

(PS: If you're interested in why we want it as XML, it's because we want to see all the possible tags that we can consume from the search.) 

Reply
19 Replies
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

‌ | ‌ | ‌ | ‌ | ‌ |

0 Kudos
Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

Interesting, as seen in my use case here:   Where I was using a repeating section and needed to parse that XML, I was able to write it directly into a plain text multi line column with no issues. Can you post some more details of your workflow and what actions you're using and how they're configured?

Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

For such case I am logging the XML structure to multiline plain text field. Remember, the field has to be plain text. 

Also, when you send it via email, it is just impossible to open it in Outlook Online. I recall I was able to view the XML structure in Outlook Desktop or that I was sending it to my Gmail. 

Anyway, using plain multiline text field does its job. 

Regards 

Tomasz 

Regards, Tomasz Poszytek
Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

I do not have experience with O365, so I'm not aware of its specifics.

but haven't you tried to simply XmlEncode it?

Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

Column Configuration:

Workflow Configuration:

Search Query Output:

The Output Into The Column:

(no XML tags) (email output looks the same)

Output Into Log History:

Is this SharePoint Environment haunted?

Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

Ah, sorry ‌ - I didn't know that!

As for XML Encoding... it already is encoded, it's just leaving this world when it's published.. I've updated with a comment below to show specifics.  

0 Kudos
Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

Rhia Wieclawek wrote:

Is this SharePoint Environment haunted?

Yes, I believe so. The only option is to burn it down, I'm so sorry.

What if you leave it as a string rather than selecting plain text?

Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

Same thing, I believe, but I'll re-run to make sure!

Reply
Workflow Hero

Re: Get XML As Plain Text in Email / Column

Jump to solution

And remember we still have no inline functions in O365

Regards, Tomasz Poszytek
Reply