Submit form data to secondary data source which is also my main data source - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Submit form data to secondary data source which is also my main data source

Last post 08-30-2022 05:07 PM by sankar.v. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-26-2022 10:48 PM

    Submit form data to secondary data source which is also my main data source

    Hello Everyone, I'm new to Infopath and this forum has been of great help recently! I'm building a Sharepoint list form and have trouble with Submit data. My SP list is one flat list with Project and Phase details where project name, contacts etc repeats where as the phase and deliverables are unique. So far I'm able to achieve the following - Connect to the same SP list as secondary and load project names into Drop down - 1st repeating table shows Project name, contact etc and I hid the repeating rows with formatting rule - 2nd repeating table shows project phases and deliverables and I filter the project data with another formatting rule which only works with secondary data source - On drop down change, I set the fields values from secondary source - I can't find a way to filter the main datasource - I tried setting field values before submitting the data from secondary fields to main with a button but it didn't work. The form retains the entry but nothing gets saved in the list I'm not sure what I'm doing wrong here. I'm open to make design changes. My requirement is just the users should be able to update multiple project deliverables in repeating table. Thanks a lot!
    Filed under:
  • 08-30-2022 04:53 PM In reply to

    Re: Submit form data to secondary data source which is also my main data source

    Hmmm - I'm not quite sure I understand. I do know that we can't submit data to a secondary data source with InfoPath out of the box, so I'm wondering if that's part of your issue. Can you attach a copy of your form to a reply under the Options tab?
    Hilary Stoupa

  • 08-30-2022 05:07 PM In reply to

    Re: Submit form data to secondary data source which is also my main data source

    Thanks a lot for your response Hilary! I'd like to update only one SP list. Since I connected to the same SP list as secondary connection for loading Drop down and setting field values, I'm unable to update the secondary list. I couldn't figure out a way to load choices from Main connection and set field values (which will avoid the secondary connection altogether). I'm attaching herewith my form.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.