Copy Table from Filtered SharePoint List Data Connection - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Copy Table from Filtered SharePoint List Data Connection

Last post 09-06-2015 03:28 PM by Rommel Sta. Juana. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-03-2015 12:59 AM

    Copy Table from Filtered SharePoint List Data Connection

    Hi,

    Good day. I just want to inquire how to use Qrules Copy Table command. The source table will be coming from a Secondary Data connection to a SharePoint list. Below is the screen shot. Also, the data connection to the SharePoint list is being filtered on load so that only items for the current user will show and these filtered items is the only one that I want to copy. Also, will the Copy Table command work for Hyperlink fields?

    Thank you in advance...


  • 09-04-2015 03:29 PM In reply to

    Re: Copy Table from Filtered SharePoint List Data Connection

     Is the data connection filtered or are you using conditional formatting on the form to hide the items you don't want to display? You can use an XPath filter in the tablesrc parameter to indicate which rows you want to copy. Check the sample form that installs with qRules for general samples for CopyTable - the Command Overview also has examples. As to the hyperlink - I don't think it would be an issue - the only requirement for copy table is that the source and destination have the same number of elements and attributes.

    Hilary Stoupa

  • 09-06-2015 03:28 PM In reply to

    Re: Copy Table from Filtered SharePoint List Data Connection

    Hi Hilary,

    Good day. The data connection is not filtered, and yes I'm using formatting to hide items. Can you please give some advise on how to use Xpath filter? As I check the sample, I was able to see the below command on the command use but do not know how to use the filter Xpath, Sorry..

    CopyTable /tablesrc=/my:myFields/my:CopyTable/my:SourceTable /rowsrc=my:SourceRow /tabledest=/my:myFields/my:CopyTable/my:DestinationTable /rowdest=my:DestinationRow /empty=no 

     

    Regards,

    Rommel 

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.