InfoPath Dev

It works perfectly, thank you! I got another request for my form :( (it will never end ;)) I got one field in which you enter the name of the employee (this field is connected with the SHarePoint library). Each employee belongs to a departement. Therefore I have a listwith two colums (Employee and department). Is it possible to connect the form with this list. So that, if one employee is selected, it automatically fills in the correct department? Thank you!!

Yep. You need to add a data connection to the list with employee / dept. How do the users currently enter the employee in the form? Do they select via a people picker or something?

Currently I can select my employee from the SharePoint "library".

Ok, so you are using a people picker in the form. In your other list with employees and departments, if the Employee field is a person or group column type, then you would be able to match on the account id to get the correct dept. Add a data connection to your list to your form, attach a copy of your form here, and I can help you.

Ok I have added a data connection via another Sharepoint list called SMT Orga with 2 Columns: Abteilung (engl.depart.) and Name1. I just realised that the query of the action items doesn´t work as perfectly as I thought it does :( When I start my query it shows ALL action items of ALL work packages. I think I did something wrong. I will show you my settings/rules I applied in the following posts. Please tell me where the mistake is :) Thank you so much! Stay healthy! Jasmin

The query I have added

The query of the button

Maybe give this one a try? It looked on your button like you were setting the title query field after you ran the query, but you'll want to do that before. I added a default value to Abteilung Mitarbeiter/Name/Kompetenz - it is making the assumption that the Name 1 field in your other list is going to match the display name from your people picker. I may be guessing all wrong here - since I can't preview, it is hard to guess. :)

Unfortunately I cant fix the issue with my action items. When I click on my button it always shows me the action items of all work packages. I tried out to many things but I cant fix it. Here again what I did until now: Work Package Query field: I set the Work Package Query field=Action item query field Button: run the query for the main data source

It works! Thank you so much!!! But when I want my form to show all my action items, this happens: My employees disappeard. I am so grateful for your help!!

Try putting just the display name from the people picker on the form in a calculated value and see if that displays. If so, you might need to use some conditional formatting rules to display the people picker vs the calculated value.... like, if Display Name is not blank, show the calculated value, and if it is, show the people picker. You could also add a little "X" button to clear the people picker in case the user needs to change after selecting.

Here is my current form. Is there a way you can preview the form? Thank you!!!

No - I can't preview the form because I don't have access to your SharePoint site. I'm also confused at this point as to what issues you still have - you had one post that indicated you were not able to get the current work items, then the next seemed to indicate you were? Can you clarify for me what you still need help with?

I just realised that the query of the action items doesn´t work as perfectly as I thought it does :( When I start my query it shows ALL action items of ALL work packages. I just want the form to show those which belong to the respective work package.

Ok. Does the rule on the button that I modified return the correct items? Is it just an issue when the form first loads?