SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
I don't understand your question exactly. But Do you retrieve data in textbox and after that you want to apply rule? – Viraj Gorajia Jan 16 '13 at 5:19
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. – Shahid Jan 16 '13 at 6:01
I have not tried but i think it will work.. Try this....…… – Viraj Gorajia Jan 16 '13 at 6:17
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. – Shahid Jan 16 '13 at 6:55
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. – Viraj Gorajia Jan 16 '13 at 7:11

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.