InfoPath Dev

I got one button in my form which has one action rule: query the main data source. Maybe I dont understand your question correctly. I have tried to show you the issue explained in one picture (attached). The third part of the picture shows that in my work package 1 all action items are shown (also those of work package 2) instead of only work package 1. Thank you for your help and sorry for disturbing you!

You aren't disturbing me, no need to apologize. So, in the attached template, on your button, I added a rule to set the query title field in the main DS to the title field in the 2ds. Then the query runs. That way only the items w/ the same title should be returned. Does that make sense?

I am glad to hear this thank you! I run the query but it still shows me all action items , nothing changed.... i start to lose hope :(:(

In this copy I've added the query title field to the form at the bottom and another button to run the query, as well as a few fields from the data field so you can test a bit - just try entering the desired Title in the query title field, and running the query from the button. See if your results are any different....This will at least give you an idea of ways to test your logic which may help figure out the issue. :)

It finally works! I set the Title query field to the tile data field and also put the value, that the title query field has automatically the same value as the title data field below. What a milestone! Thank you! I also made it that my form shows the selected employees in my calculated value field. But they aren´t editable. Could you please tell me in detail how this works? Besides that a general question: I got this form connected with a specific sharepoint list. In case I want to create another sharepoint list (with different name) which is also editable with this form, how can I connect my form with several sharepoint lists? Thank you, Hilary! You are ingenious!

And would it be possible, to enter just the department? For example sometimes there is no specific person named for the work taks, just the dep. in general. In this case if I just want to fill in my dep, it is currently not possible (the name of the dep. disappears), because no person is selected in the person picker.

I've altered the attached with a suggestion for what to do for the people picker. The department gets a little trickier - if we could add rules to people picker fields, I'd just use a rule instead of a default! You may have to add a "helper" field to your list - "SelectedUser" or something. Set the default value for the new field to the Display Name from the people picker, and add a rule to the new field to set the department. Then you don't have to use a default for the department....

Thank you! Do you know if I can connect one form with several sharepoint lists?

Oh, sorry, I'd missed that question. You can query other lists, but cannot submit data to other lists. SharePoint List forms are only able to submit to the list they are created from.

Hi! I have added following value to my fields: ../preceding-sibling::my:SharePointListItem_RW/my:xxxxxx so that, if I add another item to my form, it takes over specific field. This works well. I have also added follwong rule to my repeating section, so that is doesn´t show me all added sections: count(preceding-sibling::my:SharePointListItem_RW) > 0 This works also well. So now I want to edit one row in my sharepoint list. F.E. Iwant to edit the title field (with the value ../preceding-sibling::my:SharePointListItem_RW/my:xxxxxx)..... so is it possible that the change will be taken over to all rows with the same title field? Thank you!

It looks like you are currently using default values to set these, is that correct? There is a checkbox for updating the result when the data changes in the field's properties, have you tried checking that? I would probably use submit rules to set these instead of default values, but that is just me - if default values are working as you'd expect, it seems like they would be OK too.

I have checked the checkbox but then it deletes everything I have tiped into the field after I go to another field. What do you mean by a submit rule. You mean instead of the preceeding sibling value?

Right. See attached sample.

I can see your point. But this doesnt my (i guess) for my kind of form. I have already added a button with which i query the primary data to get all my work tasks which relate to my specific title. So if I click into one row and start the query it correctly shows me all action items. But if I change the title name in my form, the new name doesnt relate to all action items (rows) with the same title. It only changes the title of the row I have clicked. I hope I could explain my issue. Thank you

I would change the submit options to use rules, and add rules similar to those in my sample rather than using default values for the fields you only wish to have show one time. I think that will solve this issue.