<?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>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120085.aspx</link><pubDate>Tue, 20 Nov 2018 13:58:54 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120085</guid><dc:creator>mbhushan1605</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120085.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120085</wfw:commentRss><description>Thank you,
The issue is resolved now. While setting Rule to Set field&amp;#39;s value, It is set as below.

Field - Account ID  (of Column D)
Value - Account ID of column Email from User List where Filter is added as (Field3 i.e. Dropdown list value = Account ID of Display Name of User Column from User List)

I know its difficult to explain it easily however your suggest above has helped to resolve it.</description></item><item><title>Re: Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120082.aspx</link><pubDate>Tue, 20 Nov 2018 07:30:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120082</guid><dc:creator>mbhushan1605</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120082.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120082</wfw:commentRss><description>Thank you, 
Is it possible to set both account id and Display name through single rule? pls let me know how to set it?</description></item><item><title>Re: Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120081.aspx</link><pubDate>Mon, 19 Nov 2018 17:22:48 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120081</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120081.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120081</wfw:commentRss><description>You are setting a people picker? I think you need to set both the account id and the display name.</description></item><item><title>Re: Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120078.aspx</link><pubDate>Mon, 19 Nov 2018 15:28:30 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120078</guid><dc:creator>mbhushan1605</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120078.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120078</wfw:commentRss><description>All,

:) somehow i have resolved that issue by correcting my filter criteria. It is like below
While setting Fields value in Value field selected &amp;#39;Email of User List&amp;#39; Then added Filter where Field3 of Risk List = UserName of Email List) It worked well. However now i face new problem. 

So here i select name from Dropdown List of User List and based on selected name, email id of corresponding person is selected from user and displayed in Column D of Risk List. However when i click Submit, it gives below error. however when i select the person name manually in column D it works well.</description></item><item><title>Re: Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120077.aspx</link><pubDate>Mon, 19 Nov 2018 14:03:51 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120077</guid><dc:creator>mbhushan1605</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120077.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120077</wfw:commentRss><description>Just added an example to make question simple. e.g. 
I have List called Risk which have below columns
        List Risk - Column A, B, C, D  (Suppose D column is of Type Person or Group). InfoPath form works well to accept new records in List &amp;#39;Risk&amp;#39;.

Now i have new requirement to accept values of Column D using a Dropdown List. It was not possible to convert Person or Group type column as Dowpdown in Infopath form. So 

created another List &amp;#39;User&amp;#39; which have below columns
        List User - Column User, Email

In InfoPath form created data connection for List User and added a Dropdown for column &amp;#39;User&amp;#39; from &amp;#39;User&amp;#39; list. Then added a rule &amp;#39;Set Fields value&amp;#39; of column &amp;#39;D&amp;#39; when a value is selected in Dropdown of &amp;#39;User&amp;#39; column on InfoPath form. It works well, however when an user have 2 id&amp;#39;s in same organization then it gives an error. To solve this i want to use column &amp;#39;Email&amp;#39; of &amp;#39;User&amp;#39; List for the above rule. so at the end what i want is when User selects a value in Dropdown of column &amp;#39;User&amp;#39; the rule should retrieve related &amp;#39;Email&amp;#39; column&amp;#39;s value from &amp;#39;User&amp;#39; List. Please suggest how to achieve it.</description></item><item><title>Retrive value of col B, from sharepoint list which match value of Col A selected in dropdown in infopath form</title><link>https://www.infopathdev.com:443/forums/thread/120076.aspx</link><pubDate>Mon, 19 Nov 2018 13:47:19 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:120076</guid><dc:creator>mbhushan1605</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/120076.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=120076</wfw:commentRss><description>All,
I have InfoPath form which process data of List &amp;#39;Risk&amp;#39; which saves Risk details. In this List a Column as Business owner is present which is Person or Group type.
I received a requirement to add Dropdown and add fixed list of users for this field. So i created a new list as &amp;#39;User&amp;#39; where i have 2 columns i.e. User and Email, which saves username and his email id respectively. 
I have added this as &amp;#39;Field3&amp;#39; as dropdown list on InfoPath form of Risk List. I can see all Usernames from &amp;#39;User&amp;#39; List in this dropdown list. I have added a Rule which copies dropdown value from Field3 of User list to Business owner column of Risk List. 
Issue is when there are 2 email id for someone in Org, then it gives error when i select value in dropdown and it copies name in Business owner field (Person or Group type). I want that when i select person name in Field3 Dropdown email id of that value should be displayed on Business Owner column. i need to understand how to set filter condition so i can retrive correct value. Every time it fetch value from 1st row of list. 
Attached is a screen shot</description></item></channel></rss>