Hi All
I am new to this site and I am seeking help with my issue, I am really struggling below the scenario:
I am designing InfoPath Form addressed to be a leave form for the company employees
1- I created first section containing the Employee Info (Login ID, Name , Manager Name , title and department) all this information was set successfully to be filled Automatically once the Employee open the form using getUserProfileByName Data Connection
2- I created a list on Sharepoint containing the fields (total Days Balance , Required Days , New Days Balance) and added a Data Connection to my form for that list
3- I have second section on the form with three fields (Total Days Balance , New Days Balance, Employee Name ) I need once the employee opens the form the total Days Balance gets the value from that list , I set query data connection then set value of that TotalDaysBalace to get the value from that list , but the issue that it takes only the first value related to first employee in that SharePoint list , how I can set that value (totalDaysBalance) to be pulled from the corresponding value to same employee who opens the form??
and the same to calculate the new balance days in the form by subtracting it from the required days and update it in that same list
Please Note Employee Name , Total Days Balance will be filled manually in the SP list but New Balance to be updated once the form is submitted
thanks in advance for any help