-
They will not magically tie together nicely.
If you need to see all the List 2 details for each List 1 item at the same time, I think you'll have to create another 2ds using an XML file with the structure you need, then use qRules and a transform to populate it - you could probably also do something with other qRules commands, like Insert and ...
-
Item 1 is pretty easy - just use a calculated value in the column where the lookup value should go, and select the field in list one where the id matches the value of the id in list 2.
Item 2 is pretty hard. Usually what I do is add a section that I can "show / hide" and then when the user "shows" the section, I query list 2 ...
-
Since you are only returning one row in the data source, you don't need a filter on the rule to set the value, right?
-
Is there an option that just says "edit"? You may need to make sure the library is set to open in the filler (under advanced in the library settings).
-
I would expect the query to show up in Fiddler. I see in the sample template you uploaded to One Drive that you are executing the query. I would drag that data source onto the form so I could verify that the query field is being set and that the query is returning results.
-
Is it setting the query field that is causing the issue? Or actually executing the query? Can you put the query and data fields for the list connection on the form, add a button that executes the query and experiment a bit to see what values cause an error? Sorry - I don't have any idea what is going wrong here, just trying to help you ...
-
To me, it seems like the query is causing the error (the SOAP in the error message). If you just temporarily disable the query what happens? If you disable some other rules, what happens?
-
So - you are seeing an issue with rules you copied and pasted? You've double checked the rules to make sure InfoPath hasn't done anything "helpful" to them, like it sometimes does?
-
Interesting - this suggests that UDCX should work for a web service connection in a sandboxed form:
https://support.microsoft.com/en-us/kb/981684?wa=wsignin1.0
But then it also says:
the process uses the identity of the account that runs SharePoint Foundation Sandboxed Code Service. The account is specified by the farm administrator. ...
-
Here's a link on setting up a secure store application: https://support.office.com/en-ca/article/Create-or-edit-a-Secure-Store-Target-Application-f724dec2-ce28-4b76-9235-31728dce64b5
Then you'd use the name of that as the value for the /ssoappid parameter in your submit to sharepoint list command. You'd need to inject your form with ...