extract information and store as workflow variable

  • 17 November 2017
  • 4 replies
  • 2 views

Badge +1

Sharepoint and workflow 2013
I get the following information in a web service
<GetUserLoginFromEmail xmlns="http://schemas.microsoft.com/sharepoint/soap/directory/"><User Login="i:0#.w|instructional inytim01" Email="Tiny.Tim@sccpss.com" DisplayName="Tiny Tim" SiteUser="0" /></GetUserLoginFromEmail>

Question:

1) how can i extract Tiny Tim from the  DisplayName= and store it in a variable?

thanks


4 replies

Userlevel 5
Badge +14

use Query XML action with XPath expression

//@DisplayName‍

210862_pastedImage_1.png

Badge +1

Thank you very much....was just what i needed. 

I an new using query xml....could you point me to resources that i can learn more about this topic?

Again, thank you very much!!!!

Userlevel 5
Badge +14

you should look for XPath and/or XSLT to learn how to process XML documents

https://www.google.com/search?q=xpath+reference 

https://www.google.com/search?q=xlst+reference 

online testers might be useful to  practice

https://www.google.com/search?q=xpath+tester 

https://www.google.com/search?q=xlst+tester 

nintex as well provides clickable XPath builder that can be used for simple expressions.

210902_pastedImage_6.png

Badge +1

thank you very much

Doug

Reply