InfoPath Dev

Hello,

I have a repeating table where one of the columns (Name) is a Drop Down list control that is populated from SharePoint list.

I set "TItle" as the Display Name and "ID" as the value so when I press on the Drop Down I can see the Title from SharePoint but have the ID as value for later use.

I have another drop down where I choose the repeating table as the source and query with a condition.

The  Value is set to some other column and the Display Name is set to the "Name" field.

The problem is that when I press on this Drop Down, I see the ID instead of the Display Name.

What can I do?

Thank you.

 When this happens to me, I add another node to my schema.

So for example: under the repeating node, I would have a field for the ID, and a field for the DisplayName. Obviously the dropdown stores the ID and displays the displayName, but storing these separately means that I can use them later in other places in my form.

Add a rule to the dropdown such that it executes when it is not blank. With the ID stored in the dropdown, you can use a filter within Set a field's value to then extract the DisplayName from your secondary data source and save it in the second field.

Good luck!

Hi Ernesto,

Sorry to interfere in this conversation. I have a same requirement but little difference. i want to display name(Emp Name) in a list instead of "ID". I see only the "number" instead of name in place of Emp Name. I have followed the link as well. in preview this works fine. but when it comes to site(list) level, it displays only number.

the link: http://sharepointsolutions.com/sharepoint-help/blog/2011/11/get-infopath-to-display-lookup-column-value-not-id.

Please........... be elaborate. so that i can understand or else give me any link which gives me a walkthrough.

Thanks,

Hi,

The link you have posted is the same idea I had explained above, but in a step by step fashion.

The set up should not be any different for browser vs client vs preview. That is, the form should behave the same if everything is set up correctly.

Hey Ernesto,

You mean lookup over a lookup? :)

I will try and test it.

Thanks