Infopath to Sharepoint List - InfoPath Dev
in

InfoPath Dev

Infopath to Sharepoint List

Last post 08-19-2010 11:31 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-19-2010 06:05 PM

    Infopath to Sharepoint List

    Hi.  I am evaluating qRules and Submit to Sharepoint list for a specific project.  I am encountering problems with the submit to sharepoint lists.  I have watched the video demo but the form we are evaluating is constructed slightly differently.

    I am using Infopath2010 and Sharepoint2010 (enterprise).

    The form has (without the qRules addins) two drop down fields populated from other sharepoint lists (secondary datasources) and a "Run query" button.  This when run returns the rows from the main sharepoint list (again this has been setup as a secondary datasource - but does not have to if I have done it wrong) filtered to the selections made in the drop down lists.

    When I try to use the "submit to sharepoint" mapping tool I do not see any fields to map to.  I understand that it is returning the "main" fields, of which I have none.

     My question is that as the form is functioning and querying the relevant sharepoint lists, is there a way I can then submit this repeating data back to the Sharepoint list using qRules.  If this can be done then we will most definitely be purchasing the products and most likely dbxl as well.  This functionality will remoe our need for dedicated VPN's for database transactions and sharepoint lists being used for smaller datasets where appropriate.

    Any help/guidance would be appreciated.

    Cheers

    Mike

  • 08-19-2010 11:31 PM In reply to

    Re: Infopath to Sharepoint List

    Hi Mike,

    "Main" means "main data" source. The Submit To SharePoint command requires the data to be in the main data source. To get the data from your secondary data source (2DS) into your main data source, just use Copy Table to copy it into the main data source? Or, you could use the Insert Row technique which inserts a number of rows equal to the queried count and then uses rules to set the row columns equal to the values in the secondary data source (Jo-Anne Alfafara has a new blog tomorrow or Monday that will detail this).

    Better yet, you can get the beta of qRules 2.3 which roundtrips updates from a SharePoint list. That way, you don't have to copy. Of course, that assumes you are querying the same lists you are submitting to.

    We can demo this tomorrow if you are interested. Email Support (at) Qdabra (dot) com and just ask for a qRules demo and mention this thread.

    Best,

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.