filter specific Data from sharepoint list - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

filter specific Data from sharepoint list

Last post 01-27-2015 06:03 AM by ref1234. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-26-2015 10:39 AM

    filter specific Data from sharepoint list

    Hello,

    I want in my Form that when I chose a Team, it show only the Business area that is link to it in SharePoint.

    let me explain:

    In my SharePoint List, I have 2 field: Team (IS and IT)  and Business Area (all applications and infrastructure items).

    example:
    Business Area                                        team

    Gotrex Application                                  IS
    Microsoft Office                                      IT
    e-Repricing                                             IS
    Windows Server 2012                            IT 

     

    The list is really long so to help, in my Form, what I want to achieve is when I chose IS,  it bring me only the IS list that is on sharepoint. The sharepoint list is already in Data Connections with the fields.

    How can I achieve this? What rule I have to select?

    Thank you

     

    Carl 

     

  • 01-26-2015 12:13 PM In reply to

    Re: filter specific Data from sharepoint list

     Hello Carl,

    Thank you for your question. What you are asking for is referred to as a cascading filtered dropdown. In the rules on the second dropdown you can add a filter to limit the options. You can also set up the connections as 2 separate data connections to the same list. The action of selecting a value of IT from the first, sets the query field of the data connection and then queries the data source. You'll want to set the second data connection to no query on load. Here's a link to a similar scenario:

     http://www.infopathdev.com/forums/p/29365/100602.aspx#100602

    Let me know if you need more help!

    Best,
    Bre 

  • 01-27-2015 06:03 AM In reply to

    Re: filter specific Data from sharepoint list

     Hi Bre,

     it works, thank you so much for your guidance! My filter wasn't good.

    Have a nice day!

    Carl 

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.