Solved

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

Posted on 2010-11-16
2
394 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
ID: 34146028
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
ID: 34146184
Wow, that's some filtering but works a treat!

Thanks bud, you're an InfoPath Genius!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

820 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