https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120576.aspxTue, 12 Mar 2019 14:51:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120576Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120576.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120576Well, if you modify your data connection to sort by ID desc, you wouldn't have to use a filter - without a filter, your XPath will just return the first item in the list. :) This blog post has info on using XPath filters - maybe it will help you? http://codelesssharepointinfopath.com/infopath-using-the-filter-option/https://www.infopathdev.com:443/forums/thread/120573.aspxTue, 12 Mar 2019 04:35:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120573eduva0https://www.infopathdev.com:443/forums/thread/120573.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120573Hey, I am sorry, but I am still struggling with this. Can you please share some good manuals/videos I can watch for this?https://www.infopathdev.com:443/forums/thread/120555.aspxFri, 08 Mar 2019 17:22:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120555eduva0https://www.infopathdev.com:443/forums/thread/120555.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120555Hi, thanks for answering! I dont a sample form. The list is in the company site and I dont have permissions to share it to outside the company. I truly cant find some good guides for beginners, from the creation of the data connection, to filtering the connection, to filling the current item fields. I finally found how to choose the data connection I created in the "Fx - Insert formula" option of each field of the current item. Now, how do I choose the max id of the list and use that as a filter to query the list and get the data and automatically fill the fields I chose? As long as I get one clear and detailed example, I am sure I can manage. Thankshttps://www.infopathdev.com:443/forums/thread/120553.aspxFri, 08 Mar 2019 16:06:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120553Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120553.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120553Do you have a sample form with a data connection that queries the list? Attach it to the Options tab in a reply & I can give you a hand setting up a few approaches. You'll probably find a sample helpful. :)https://www.infopathdev.com:443/forums/thread/120548.aspxFri, 08 Mar 2019 00:38:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120548eduva0https://www.infopathdev.com:443/forums/thread/120548.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=120548Hi, I am new to this forum so I don’t know if this is the right place to post this. I have a form connected to a sharepoint list and a submit button that creates new items to that list. I need a way to auto fill some fields of the form with the information of the last item created in the same list the form is based on. I know absolutely nothing of how to do that. I have seen countless posts about creating a secondary connection and use that with a form load rule that will fill the fields I chose. I have seen suggestions of choosing the max id of the list to filter the query. But I simply don’t know how. I read about how after creating a data connection to the sharepoint list you gotta go the field properties, the Fx (formulas) option and then choose the field of the the data connection I created but I can’t find those fields, I can’t choose another connection all I see are the fields of the current item I am on. Can I get some detailed explanation of how to get the max id of the same list the form is loaded into, and automatically fill the fields I chose? It doesn’t even have to be automatically, if there is an extra step of pressing a button to do it I would gladly accept it. Even if I can’t get the max ID automatically I have absolutely no problems in having the user go to the sharepoint list, choose the ID of the item they just created, and write it down on a field in the form to use as a filter to query the data of that item ID. Thanks in advance