How to use CustomList data in InfoPath Expression?

Question

How can I read/use the CustomList data in InfoPath Expression/Rule ?

I want to take necessary action after reading the data of CustomList using Rule/Expression for my calculation.

I don't want to bind this data to dropdown list. That's I have done it.

But I want to apply rule on my textbox based on my CustomList declared in my SharePoint site.

I don't understand your question exactly. But Do you retrieve data in textbox and after that you want to apply rule?
Yes. I have 2 textboxes. I have stored start & end date in each textbox respectively. I want to find working days in the other textbox based on holiday declared in customList which is coming in these start & end date. That's why I want to apply rule for this.
I have not tried but i think it will work.. Try this.... bizsupportonline.net/infopath2007/… bizsupportonline.net/browserforms/…
I have used this. Its working fine. But now just I need to add(consider) the Holidays which are declared in my CustomList, which is fall in between the start & end date.
Then you need to compare one by one date which is fall in between start date and end date with holiday date from custom list.

Геннадий-Ванин · Answer 1 · 2013-01-22 12:32:04Z

Create a secondary data connection to your CustomList. In Infopath Designer, on ribbon Data tab > Data Connections > Add... > etc.

Click Insert Field or Group... button where you have created Xpath expression, navigate and choose your Data field.

1 Answer