General

Re: repeating table does not show duplicate lookup value

Masoud — Fri, 17 Feb 2023 21:35:49 GMT

Thanks Hilary, my problem was when i create data connection to share point list that there are look up id there , it did not not show that field,

the value of that look up id in share point list was like (155;#155) or (Lookup id;#Lookup id) .

any way tried to create another column in share point list and with share point designer make the value of new added field for example (155) without (;#), after update data connection i could see new added field and use that for filtering in master/detail form. now my problem has been solved but still I do not know what is the best practice.

Re: repeating table does not show duplicate lookup value

Hilary Stoupa — Thu, 16 Feb 2023 00:58:01 GMT

I'm not sure which view or field I should be looking at here. Your main data source is not repeating, so you will only ever have one item in the main data source. There is no easy way in InfoPath to copy repeating data from a secondary data source to a main data source, if that is what you are trying to do?

repeating table does not show duplicate lookup value

Masoud — Wed, 15 Feb 2023 05:52:40 GMT

Hello according to attachment in my form i have a repeating table that there is a lookup value to id of Main field. for each id in the main I have 2 or 3 items in repeating table but in repeating table just show one item while should show more items. also, for test without using query fields, i added repeating table, also does not show duplicate lookup value while in my SharePoint library there are more than records. i have attached file. Regards, Masoud