I want to display data in the sharepoint list onto the infopath form.

I have a connection made and I can view the information on the sharepoint list in the infopath form. But I added a textbox on the infopath form I want to write 111 there and than filter data viewed on the infopath form to only data that has id=111 . When I dont enter anything to the textbox nothiing appears when i enter 111 all the list comes but I only want the record with the ID=111 .How can I achieve this? , although i put rule for that i could not do it ..how can i do it ..you can check what i say on the screenshot....  Tnx
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
i assume you are using a repeating table control to display the list data. Go into the properties and the display tab, select conditional formating. Add ID not equal to 111 and then select Hide. This will hide all records but what meet your criteria.  
You can replace the 111 with your select field.

Play with it and get used to how it works.
www.infopathdev.com is a good resource too.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fatihdiAuthor Commented:
when I click repeating table properties there is no conditional formatting ,I see filter data instead and i set TCID!= 111 but now it shows everything no matter what the whole list that is not what i want
How is the form setup to bring back all the data from the library? What does your datasource look like? Is the SP list a primary or secondary data source?
fatihdiAuthor Commented:
it helped but did not resolve exactly..
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Theory

From novice to tech pro — start learning today.