General

Re: filtered dropdown returning ShP id

BryanJones — Thu, 10 May 2012 15:01:27 GMT

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.

Re: filtered dropdown returning ShP id

Hilary Stoupa — Fri, 30 Dec 2011 23:32:54 GMT

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

Re: filtered dropdown returning ShP id

MrWilde — Fri, 30 Dec 2011 23:25:06 GMT

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

Re: filtered dropdown returning ShP id

Hilary Stoupa — Fri, 30 Dec 2011 22:53:54 GMT

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. :)

Re: filtered dropdown returning ShP id

MrWilde — Fri, 30 Dec 2011 22:46:52 GMT

Some fantastic resources there, thanks so much Karsten

Re: filtered dropdown returning ShP id

MrWilde — Fri, 30 Dec 2011 22:46:29 GMT

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

Re: filtered dropdown returning ShP id

Hilary Stoupa — Fri, 30 Dec 2011 18:23:42 GMT

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

Re: filtered dropdown returning ShP id

Karsten Brocksieper — Fri, 30 Dec 2011 15:39:32 GMT

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,

Re: filtered dropdown returning ShP id

MrWilde — Fri, 30 Dec 2011 10:07:31 GMT

Could you provide a link to those videos Patrick

Re: filtered dropdown returning ShP id

jaxkookie — Mon, 18 Jul 2011 12:42:02 GMT

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.

Re: filtered dropdown returning ShP id

Patrick Halstead — Fri, 24 Jun 2011 18:46:50 GMT

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

Re: filtered dropdown returning ShP id

jaxkookie — Fri, 24 Jun 2011 18:31:06 GMT

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..

filtered dropdown returning ShP id

jaxkookie — Thu, 23 Jun 2011 20:14:30 GMT

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