Solved

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

Posted on 2010-11-16
2
395 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Suggested Solutions

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…
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

738 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