AnsweredAssumed Answered

Question on filtering using Query XML action.

Question asked by ctoper11 on Jan 31, 2018
Latest reply on Feb 2, 2018 by emha

Hi all so I have a rather large XML file (about 253k rows) stored in SharePoint library. I'm pointing to it and connecting just fine but clearly I need to filter this to a manageble size. I've pasted the schema template below. 

 

Basically I have a SharePoint list that this workflow is attached to. I would like to filter using the Last Logged in User to pull any Installed apps that are associated with that UserName. Ideally I would put the username in my list field click submit fire the workflow and have it spit out in a text file the filtered XML that has that User's applications that are associated with them. This make sense? Can it be done this way. Thanks in advance.

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<DATA>

       <LAST_LOGGED_IN_USER ID="UserName">

                                   <COMPUTER_NAME>"Name"</COMPUTER_NAME>

                        <INSTALLED_APPS_WINDOWS_FRS>Adobe Acrobat Reader<INSTALLED_APPS_WINDOWS_FRS>

        <LAST_LOGGED_IN_USER>

        <LAST_LOGGED_IN_USER ID="UserName">

                                   <COMPUTER_NAME>"Name"</COMPUTER_NAME>

                         <INSTALLED_APPS_WINDOWS_FRS>Adobe Acrobat Reader<INSTALLED_APPS_WINDOWS_FRS>

        <LAST_LOGGED_IN_USER>

</DATA>

Outcomes