I'm at creating a section in InfoPath13 where users can select an item (a certain job) that has a certain price and a certain number of hours to be spent on it.

I'd like to create form where users only need to pick from the item name and they will get the price and the hours to be spent automatically populated from the list connected via data connection.

Figure 1:

SharePoint list the information should be pulled from Figure 2:

The way it should look like in the form

  • It is not clear if the form controls are a repeating table. It is not clear if the form controls are bound to the main data source or the secondary data source. It is not clear if you want to copy values or just display values that have been looked up. You need to provide more information. Edit your question to do that, then post a comment.
    – teylyn
    Apr 28 '16 at 21:05
  • They could answer my question with the same details on an other forum. Thank you. Apr 29 '16 at 7:26
  1. Go to Hours column textbox property
  2. In default view textbox, Click on Fx button
  3. Click on Insert Field or Group..
  4. Select secondary data source (Your list) from above dropdown
  5. Select Hours field
  6. Click on Filter button
  7. Set condition like Item(Secondary data source) = Item(Main source Dropdown)
  8. Save it
  9. Same steps for Price field
  • Thank you for this Viraj. Unfortunately it hasn't sorted the issue. Apr 28 '16 at 14:05
  • What issue you are facing? There should be no issue on this Apr 29 '16 at 8:39
  • It does not pull all row data. Maybe I do something wrong - even if it seems to be so easy. Apr 29 '16 at 10:08
  • If you select First, it will pull 1 & 10 from secondary data source. Recheck all steps. You will get result. It might be issue regarding wrong condition. Check condition. Apr 29 '16 at 10:30
  • Sorry i have updated answer. I have written wrong condition. Please check it. Now it will work. Sorry again. Apr 29 '16 at 10:35

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.