Infopath. In my infopath form. I want to show the teamName as "team 1" value but it is displaying "1" number instead of "team 1". The TeamName is a lookup column in the ProjectList.
I you are using a SharePoint list which has a column as a lookup column which then looks up another list, Ensure this column is Pulling the "Title" not the ID.
This link may help you guys.. http://sharepointsolutions.com/sharepoint-help/blog/2011/11/get-infopath-to-display-lookup-column-value-not-id/
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.
Value should be TeamID and name should be TeamName. It works like normal asp dropdown where you specify id as datavaluefield and text as datatextfield.