InfoPath Dev

Hi,

I am trying to filter the sharepoint list and display it in repeating table, In my form i have 3 repeating tables which use same secondary data source to populate but the formatting roles are different.

The column that i am displaying is an multi lookup column in the repeating table.

The display part i am able to achieve but as i am displaying multi look column of the list there is a high possibilty of redundant data.

Can anyone help me writing some Xpath or rules to avoid duplication in repeating table.

 Thanks!!!

Can you attach a sample form under the Options tab?

Hi Hilary, I have attached the form for reference . In addition to that can you please let me know whether adding a column to display sequence number to this repeating tables is possible?? I mean kind of Serial no. Thanks!!

Hi - so what is the result you are getting with your current formatting rules? I don't see anything that really stands out as incorrect here....

I have attached the overview of data present ,

• In the attachment Sharepoint list shown, col1 is single lookup column from other list and the other is multi  lookup column which i am displaying in repeating table.

The above i am doing on selection of values from Dropdown+ multi box1 + multi box 2

• so the resultant repeating table will have repetition for example if i select A1 and B1, It will display India twice thats what i wanted to avoid.

Thanks!!

Hi

Can anyone help me in this regard. The important part is like i need to acheive this through rules or actions otherwise writing the code for tackling this would have been little easy.

Sorry, your screenshot didn't make sense to me - could you preview that sample form you sent me, and take a screenshot of that, where you demonstrate how your current form is NOT working? Thanks!

Please find attached the screenshot overview which has duplicates in the repeating table linked to secondary datasource(Sharepoint list data ).