3

I have a problem with repeating table and display data using this table.

I try to display a elements from list “Wydarzenia” (Events) in my form design in InfoPath. I add Client using InfoPath form. After that I create Wydarzenie and choose Client from dropbox list. This drop list is reference type.

Wydarzenia (Events list)

This list shows all events. I try to display ony those that have ID equal to the client. The last column is ID (value take from library when I create new Client).
Down on the picture you can see "Identyfikator Klienta" (Client ID). How I can put to this field value of ID from library Client?

If something is not clearly just write, I'll try to explain more.

Best regards!

Improve this question
2
  • thank you very much, repeating table filter works for me. Commented Mar 20, 2013 at 14:13
  • 1
    Please don't add "thank you" as an answer. Once you have sufficient reputation, you will be able to vote up questions and answers that you found helpful. Commented Mar 20, 2013 at 15:39

2 Answers 2

Reset to default
4

As I understood, you have a receive/secondary data connection/source to a sharepoint list rendered as repeating table which you want to filter in an Infopath form template by some value.

So, having created and filled a list.

enter image description here

In IP form template I've created a drop-down list to choose titles by which to filter a repeating table

enter image description here

enter image description here

enter image description here

While the repeating table without filtering show all list items

enter image description here

For this I created a drop-down list box TitlesToChooseFrom getting choices the same secondary data connection to a list

enter image description here

For filtering in Fields pain I choose data source of repeating table (SharepointListItem_RW group) > Manage Rules on ribbon > New > Formatting > Hide this control for value(s) of Title in repeating table (bound to a secondary data source ClientList, in my case) which "is not not equal" to a chosen one in drop-down list (Main data source)

enter image description here

Improve this answer
2
  • This is what I'm looking for! :) Thaks a lot! Commented Sep 4, 2012 at 6:16
  • Wonderful.. Have been trying to do this since last 1 week !!! Commented Mar 29, 2015 at 7:19
0

You could also add another Data Connection (exactly the same) and filter it.

To do this you need to add a rule for drop down control when the value of this control changes.

Then you need choose action to set fields value and set a query data of this new Data Connection.

After that add another action in the same rule - query data and select this new DataConnection. Attach new data connection to the repeating table and that's all.

Nice description about this is here: https://wmostafaw.wordpress.com/2012/08/07/calling-web-service-from-infopath-2010-with-parameters/

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.