InfoPath Dev

Ah, I understand the confusion. Yeah, even qRules Submit To SharePoint list only submits from main data sources. :) Glad that sorted it!

This is a secondary data source? InfoPath won't submit anything but the main data source. The secondary data in your form is just a copy of the data from when you queried it..... Maybe I don't understand the question?

So - I think that yes, you could do this. You'll need to use a concat formula - concat(fieldwithURL, "/", fieldwithpicturevalue) for example, and use that for the default value of a field that is bound to a linked pic. Simple sample attached. Save the file locally, right click, select design & preview. You'll see in my sample ...

Maybe check your ULS logs - I wonder if the REST URL you are using would be displayed there & then you could try the same URL in the browser. Or put your same concat in a test field as the default value so you can put that on the form, copy out the URL & verify you get results in the browser?

Interesting that there is no error - if the query failed to execute due to loopback check I'd expect an error. If you put the data fields from the secondary data source on the form so you can see them in the browser form, does any data get populated? What about getting rid of the %20 in your concat for your filter - I've never encoded ...

 For item 1 - to submit data to the database, you need to add the field in the mapping on the Database tab in the DBXL Admin tool. As to item 2 & 3 - you may need to submit a support ticket for those, but let me have Jim take a look at this post & see if he has some suggestions.

 Interesting - I'm Windows 10 & 64 bit. I'm including a screenshot w/ version info.

So - this is the type of thing where I think it is helpful to go ahead and add another field in your repeating data source. I've done that in ResSecIndividual with a default value that should return true if all three items are present for a person. Then you can just check to be sure all instances of this helper field are equal to true as well ...

So - this is when you try to export to Excel from InfoPath? or when you try to open the list in Excel from SharePoint in the browser? I use InfoPath 2013 & Office 2016 and just tried exporting data from a form to Excel from InfoPath & didn't have any issue.... Reading your post more closely, it does sound like you are talking about ...

So - a lot depends on your data structure, but it seems like something XPath should be able to handle - any chance you can attach a sample form under the options tab? I started to create one but realized I had too many questions. :)