https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120797.aspxWed, 10 Apr 2019 15:24:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120797Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120797.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120797Put the lookup fields on the form so you can see the values in them, if you haven't already - I often just drag the entire data source onto the form so I can see the actual values. It may be that the data is returned as ID;#Title or something and you need to use a substring formula to get the right value to set your query field in your second data connection.https://www.infopathdev.com:443/forums/thread/120796.aspxWed, 10 Apr 2019 09:17:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120796lucky4anshh0https://www.infopathdev.com:443/forums/thread/120796.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120796Hi Hilary, Thanks for responding to this request. Unfortunately, I will not be able to attach the form here due to the data privacy policy of my company. Is there any other way to do it? I have applied rules to the PIN No. dropdown and can retrieve details which are in"Single Line of Text" but can't retrieve details for columns which are set as "Lookup" in List settings.https://www.infopathdev.com:443/forums/thread/120780.aspxTue, 09 Apr 2019 14:35:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120780Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120780.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120780So - at a high level, the user would select the PIN from a dropdown (connected to the Project Tracker list) then your rules would query the Project Region list for the selected region ID, and populate the data. I'm not sure why you need another dropdown that shows the text for the region? I could probably help you set this up if you attach a copy of your form to the Options tab....https://www.infopathdev.com:443/forums/thread/120778.aspxTue, 09 Apr 2019 11:20:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120778lucky4anshh0https://www.infopathdev.com:443/forums/thread/120778.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120778Hi, I am new to SharePoint and Infopath. Currently I am working on a project. I have arrived at a road block where I have to retrieve data from 2 Data Connections. Here's the scenario: 1) I have to pull data based on PIN No( I have created a dropdown with receive data connection of that particular list name Project tracker) 2) I have a region option which fills in automatically when PIN No is selected. But, the Region is a lookup column from another List(named Project Region). Therefore, when pulling up the data, it retrieves the ID. To avoid this, I have created another drop down which shows the text. Now, my question here is how do I link PIN field in a way that I can connect 2 Data connections together and the value gets updated in the region field.