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? Jan 16, 2013 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, 2013 at 6:01
  • I have not tried but i think it will work.. Try this.... bizsupportonline.net/infopath2007/… bizsupportonline.net/browserforms/… Jan 16, 2013 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, 2013 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. Jan 16, 2013 at 7:11

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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