[Webinar] Streamline your web hosting managementRegister Today


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

Posted on 2010-04-08
Medium Priority
Last Modified: 2013-11-13
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
Question by:fatihdi
  • 2
LVL 28

Accepted Solution

Clay Fox earned 1500 total points
ID: 30117403
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.

Author Comment

ID: 30173979
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

Expert Comment

ID: 30211637
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?

Author Closing Comment

ID: 32146232
it helped but did not resolve exactly..

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What is Waterfall Model? Waterfall model is the classic Software Development Life Cycle method practiced in software development process. As the name "waterfall" describes, this development is flowing downwards steadily like waterfall, i.e., procee…
Dependencies in Software Design In software development, the idea of dependencies (http://en.wikipedia.org/wiki/Coupling_%28computer_programming%29) is an issue of some importance. This article seeks to explain what dependencies are and where they …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

613 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question