<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>InfoPath 2010</title><link>https://www.infopathdev.com:443/forums/142.aspx</link><description>Are you exploring new features coming up in 2010? Share information and ask questions here!</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Cascading dropdowns with infopath and lookup value from a sharepoint list</title><link>https://www.infopathdev.com:443/forums/thread/101385.aspx</link><pubDate>Tue, 24 Feb 2015 12:07:58 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:101385</guid><dc:creator>miniil</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/101385.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&amp;PostID=101385</wfw:commentRss><description>Hello,&lt;br /&gt;

I have got two lists on my SharePoint site.&lt;br /&gt;&lt;br /&gt;

First one contains levels :&lt;br /&gt;&lt;br /&gt;

Level 1&lt;br /&gt;
Level 2&lt;br /&gt;
Level 3&lt;br /&gt;
&lt;br /&gt;
A second list contains activities associated with levels :&lt;br /&gt;
In this list Level is a lookup on the first list.&lt;br /&gt;&lt;br /&gt;

Activity 1 - Level 1&lt;br /&gt;
Activity 2 - Level 1&lt;br /&gt;
Activity 3 - Level 2&lt;br /&gt;&lt;br /&gt;

I have created an Infopath Form (for a third list : Demands) witch contains 2 drop downs (Activity and Level) so when we choose the activity in the first dropdown, the second dropdown (Level) only shows levels matching the selected activity (Cascading dropdown)
&lt;br /&gt;&lt;br /&gt;
My problem is that I got the ID of the levels in stead of the values (because Level is a lookup in my second list and sharepoint store ID).
&lt;br /&gt;&lt;br /&gt;
For example, if I choose &amp;quot;Activity 1&amp;quot;, I&amp;#39;ll have &amp;quot;1&amp;quot; in stead of Level 1.
&lt;br /&gt;&lt;br /&gt;
Is there a way to have the value in stead of the ID in this case?
&lt;br /&gt;&lt;br /&gt;
Thanks for your help and excuse me for my english.&lt;br /&gt;</description></item></channel></rss>