Link to home
Start Free TrialLog in
Avatar of fatihdi
fatihdi

asked on

SHAREPOINT LIST , INFOPATH FORM HOW TO QUERY FROM THE FORM AND GET RELATED DATA TO THE FORM

HOW CAN I QUERY THE SHAREPOINT SITE LIST FROM THE INFOPATH FORM SAYING THAT BRING ME THE RECORDS THAT HAVE THAT TC-ID  SO I HAVE A TEXTBOX AND A BUTTON ON THE INFOPATH FORM AND BELOW I HAVE THE FIELDS FOR THE DATA IN THE LIST IN SHAREPOINT SITE WHEN I RUN THE FORM IT BRINGS ALL THE PEOPLE IN THE LIST BUT I WANT IT TO COMPARE IT WITH THE VALUE THAT I TYPE ON THE TEXTBOX AND BRING ONLY THOSE FROM THE LIST...when i look at the code for button click it is VB code, i know c# but i dont really know VB ....I am sending you the vb code screenshot and also the infopath design form ...what should i do...tnx
sort.png
vb.png
ASKER CERTIFIED SOLUTION
Avatar of Clay Fox
Clay Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of fatihdi
fatihdi

ASKER

Hi
    I have done what you said for example I am trying to say " show me the records that have the TC-ID  (this is the datafield in the list)  that  I type into a textbox area" so I put a textbox and then try to view only records that have the same value as in textbox but somehow if i dont type anything into textbox nothing appears if i enter a TC-ID that exists all list is coming which I only want one record...my condition that I put to the table is...if TC-ID is equal to field9(textbox) ...what am i doing wrong why dont i see only one record and rest is hidden although my rule should provide this?
Make sure you are using conditional formating properly. Typically you enter criteria TC-ID NOT equal to field9, Hide
That way if a tcid does not match it is excluded

some times you can have issues with formatting, uppercase, extra spaces, different number types.  I would try a static variable to test first, then I often use expression boxes with no formatting of each field to verify what the values are raw and do they match.  Then you can use functions to clean them up if you need.
Avatar of fatihdi

ASKER

it helped but did not solve it 100%