Capture.PNG

<div>
<div class="content wysiwyg-content">
I have a repeating table with 5 columns that accesses 1 field of a SharePoint List Data Connection. Users will potentially repeat this table 5 times or more. Thus, I would like to prevent them from making the same selection twice.<br />
<br />
I was going to follow this thread to create data validation if a user were to make the same selection twice:<br />
<a href="http://www.infopathdev.com/forums/t/10670.aspx" rel="ugc">http://www.infopathdev.com/forums/t/10670.aspx</a><br />
<br />
But I was wondering if you could Filter the SP list so that after a user makes one selection it would remove that value from being able to be selected again? If so, how would I go about this?
</div>
</div>


I have a repeating table with 5 columns that accesses 1 field of a SharePoint List Data Connection. Users will potentially repeat this table 5 times or more. Thus, I would like to prevent them from making the same selection twice.

I was going to follow this thread to create data validation if a user were to make the same selection twice:
http://www.infopathdev.com/forums/t/10670.aspx

But I was wondering if you could Filter the SP list so that after a user makes one selection it would remove that value from being able to be selected again? If so, how would I go about this?

Filter Duplicate Values from a Data Connected Repeating Table?

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.