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 'Risk'.
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 'User' which have below columns
List User - Column User, Email
In InfoPath form created data connection for List User and added a Dropdown for column 'User' from 'User' list. Then added a rule 'Set Fields value' of column 'D' when a value is selected in Dropdown of 'User' column on InfoPath form. It works well, however when an user have 2 id's in same organization then it gives an error. To solve this i want to use column 'Email' of 'User' List for the above rule. so at the end what i want is when User selects a value in Dropdown of column 'User' the rule should retrieve related 'Email' column's value from 'User' List. Please suggest how to achieve it.