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!

  • thank you very much, repeating table filter works for me. – user15765 Mar 20 '13 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. – Eric Alexander Mar 20 '13 at 15:39

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 | |
  • This is what I'm looking for! :) Thaks a lot! – Krzysztof S. Sep 4 '12 at 6:16
  • Wonderful.. Have been trying to do this since last 1 week !!! – user40951 Mar 29 '15 at 7:19

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, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.