InfoPath Dev

I have read thru many posts for this issue, but all of them deal with a one to one ratio. I have a ShP list, the items have  multiple lookup fields. so  a row item for a region could contain many locations in that lookup field "Location". When applying the filtered data source my location dropdown returns the item ids from the original location list. When populating the values there is no way to select title for display name and ID for value. the only field to select is "Value". the "Value" seems to be the default for all the multiple select items. I can filtr the drop down, but I am only getting the source ID, or parent ID. I cannot figure out how to convert this the the parent Display Name or "Title". I have been trying to add another field to set the location value. Or maybe it is a rule that needs to be Applied.

Help please

After some long research i have found out this is not doable out fo the box for SP 2010 and IP 2010. Looking at the SP page elements the lookup column has a dispaly name and value and its the value returned to the data source. I figured maybe there was a way to concatenate the entire string and using the string as a data source. It semi worked. Now I get one result. All the ID snad titles are visible. Now I need to figure out a way to parse this string and set each title as a new selection or option in the dropdown. my string looks like this

2354#PVC item;13#Elbows and T's;..

what i want to return in my dropdown is

PVC Item

Elbows and T's..

Are you using ShP 2010 OData support? That should do it for you just fine and we have videos and training to prove it.

Thanks Patrick,

 This was not an easy out of the box solution. No matter what I tried I was not able to return the display name. So I reversed my attempt and setup my lists the other way. Instead of my region being the parent and looking up my locations, I setup a locations list that linked back to regions. Although this allowed the one to many I needed to use the ID for the filter because of the lookup field. I was able to populate a secondary textbox with the location display name, but i am not loving this solution. at least in 07 this was much easier to achieve.

Hello MrWilde,

you will find a lot of videos regarding InfoPath topics here:

http://www.youtube.com/user/symwongaton

Especially for 'filtered dropdowns' there are the following videos:

http://www.youtube.com/user/symwongaton/search?query=filtered+dropdown

Regards,

If you are interested in something on OData for SharePoint 2010, try this. It may have been the one Patrick was referring to.

Thanks for that Hilary. I watched those videos just the other day and helped me solve a problem I had been working on for a while.

Much appreciated. If I may ask for just a little advice?

I was able to to update my REST query with the information from the previous drop-down, but the value is the ID and not the DisplayName. I need to update the URL with the DisplayName from the previous drop down but not sure how to populate the URL with that and not the ID. I believe I need to write an expression that will do this but not sure how.

Any links to reference material or suggestions would be greatly appreciated. Look forward to more videos

thanks again Rob Wilde

You will need to write an expression - basically, you select the field in your secondary data source that holds the value of your display. You add a filter (there's a filter data button you can use). The filter will be "field from secondary data source that contains the ID" is equal to "field in my form that is bound to the drop down control". If you need a hand, you can attach your template under the Options tab when you reply and I can help you out. :)

 OMG that is awesome Hilary! :)

I spent several days working on this problem (fairly new to infopath) and almost gave up hope it would work. Thank you so much

Have an awesome NYE.

Rob Wilde

Glad you got it sorted out - you can kick out 2011 in a happy frame of mind now!

I realize this was a while ago, but can you tell me how you were able to get the ID#Value; format out of the lookup column? This is exactly what Im trying to do but i cant select both (ID and Title), it will ony let me choose whatever the value is for the lookup.