I can receive data from a list in InfoPath, and data, but I want to filter the data and show it in a drop down list in InfoPath.
If at all, how can data from a SharePoint list be filtered in InfoPath?
View Complete Post
i have the following problem, i designed an Infopath form which should display the data (in a repeating table) from a SharePoint list, which is connected to the form.
I found the following code in the internet to copy rows from a sharepoint list to a repeating node in the Main data source and followed the tutorial.
Public Sub CTRL48_6_Clicked(ByVal sender As Object, ByVal e As ClickedEventArgs)
Dim secDSNav As XPathNavigator = DataSources("Projektsummary").CreateNavigator()
' Zeilen aus der Projektsummaryliste auslesen
Dim rows As XPathNodeIterator = secDSNav.Select( _
'Dim Current As XPathNavigator
'Loop durch die einzelnen Zeilen der Liste
Dim name As String = rows.Current.SelectSingleNode( _
Dim nummer As Object = rows.Current.SelectSingleNode( _
' Werte der wiederholten Tabelle (main data source) übergeben
I was wondering if it is possible to create a data connection to a SharePoint list that could be filtered and then displayed on an InfoPath Form.
I have an InfoPath web enabled form that gets published to a SharePoint site. I need to add a list box to the form that gets populated with data returned from an existing call to a SQL Stored Proc.
As the form works now, the user types in a patient id #, then clicks a button that calls the Stored Proc and returns any patients that match the given patient ID. This part works.
My task is to add a list box so that if more than one patient is returned , display the list box with all of these patients populated in it.
I am hoping to do this within the confines of the existing code. The existing code looks like this:
private bool LoadPatientInformationFromDB(string patientId, string patientFirstName,
string patientLastName, string patientMiddleInitial, string birthDate, string gender,
string admitDate, string location)
bool completed = false;
//Load from DB
SqlConnection conn = new SqlConnection(GetOrderSetDBConnectionString());
//Create Form Builder
formBuilder = new FormBuilder();
SqlDataAdapter adpt = null;
if (!String.IsNullOrEmpty(patientId) || !String.IsNullOrEmpty(patientFirstName) ||
!String.IsNullOrEmpty(patientLastName) || !String.IsNullOrEmpty(patientMiddleInitial)
i have two dropdowns in my Custom form.
One drop down displays all the list titles present in the current site.
i want to update another drop down with the list of columns(Field Names not the items).
i am able to get list named in one drop down but i am not able to figure out how to dynamically populate the another drop down with list of columns