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? – 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.... bizsupportonline.net/infopath2007/… bizsupportonline.net/browserforms/… – 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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