Solved

Setting infopath drop down list boxes to equal different fields from one selected item

Posted on 2010-11-16
2
391 Views
Last Modified: 2012-05-10
Hi all, not sure if this is possible, but I require the following:

I have two drop down list boxes that are conntected to the same SharePoint list called 'Approvers.' In the approvers list there are two columns: Name [people field] and E-mail [text] The data connection called Approvers is linked to these two fields

What I require is that when a name is selected in the first drop down list, populated from the Name column, the corosponding email address for the name is shown in the second drop down list. I have a broswer enabled form so filtering is not allowed

0
Comment
Question by:DJSharepoint
2 Comments
 
LVL 15

Accepted Solution

by:
melli111 earned 500 total points
Comment Utility
You can filter it by a rule instead.  What you do is add a rule to the dropdown that contains the manager's name.  Select "Set a fields Value".  For the field to set, select the dropdown that contains the email addresses.  For the value select "insert field or group", select the email field from the sharepoing list, then click the filter button, and select in the first dropdown box of the filter dialog the dropdown field that contains the manager's name (from the form); then in the second dropdown select "is equal to" and in the third dropdown box select the manager's name field from the sharepoing list.
0
 

Author Closing Comment

by:DJSharepoint
Comment Utility
Wow, that's some filtering but works a treat!

Thanks bud, you're an InfoPath Genius!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Before you can digitally sign infopath forms, you must have a digital certificate. Microsoft Certificate Services will need to be enabled on a Windows Server 2008 to facilitate the creation and verification of the digital certifciates on the web ser…
A procedure for exporting installed hotfix details of remote computers using powershell
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now