Forms Designer Forum

I am trying to convert an Infopath from that has a control that does a data connection to another list to populate the dropdown then puts that into a single line text column in the current list. I know I can create a list lookup to do that but I want to preserve the information in the current list. Is there a way to do the Dropdown population like Data Connection does in Info path.

Hello, Jennifer!
I think what you describe can be done, but we need more information about what specifically you want to achieve. If I understand correctly, you have a dropdown field which you want to populate based on some information from another list. Is this a choice field or a lookup field? And what information do you want to get from another list?

Using Lookup at some point would be best, especially Cross-site Lookup which can be filtered in variety of ways, but it should also be possible with CAML requests, so please, let us know the details and we'll try to suggest best solution for you.

The SharePoint Column is a single line of text. There is a drop down control in the infopath form that is connected to a sharepoint list through data conncetion (Not through a lookup) when the form is submitted the infopath form writes the value back to the sharepoint list single line of text column.

Okay, so there are two options I can offer for you:

1) Simply use a Lookup. You can attach JavaScript to copy value from the Lookup and you can even get several fields at the same time using Cross-site Lookup. This is the easiest and most convenient way.

2) You can use CAML request. It will make a request to another list, retrieve information from it and based on this information, you can fill the field with that you want. Here is more information about CAML requests - https://msdn.microsoft.com/en-us/librar ... e.14).aspx

We'll be glad to answer any questions you might have about either of the methods.

If you decide to go with the second option and need our help writing the code, you can write us a detailed request to support@spform.com

We'll evaluate your request and see how much time it will take us to implement, and then you can buy extra support minutes from our store, so we write and test all the code for you.