https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124229.aspxTue, 29 Jun 2021 14:43:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124229Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124229.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124229When you set up the data connection, on the last screen, there is a checkbox for returning data on form load. Deselect that. But keep your sorting as you currently have it. Then, in form load rules (or whenever you know the ID - maybe there is something the users do or select that indicates that), you can set the ID query field in the list connection, and run the query. At that point, you'll have only rows for that ID. Does that make sense? I'm not sure when / how you know the ID in your form - but hopefully using query fields will help. :)https://www.infopathdev.com:443/forums/thread/124228.aspxTue, 29 Jun 2021 13:44:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124228CsabaBekesi0https://www.infopathdev.com:443/forums/thread/124228.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124228the screenshot attached indicates what I was trying to refer to.https://www.infopathdev.com:443/forums/thread/124225.aspxTue, 29 Jun 2021 11:45:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124225CsabaBekesi0https://www.infopathdev.com:443/forums/thread/124225.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124225Thanks for your response Hilary. That is exactly the piece I am not sure how to address. If I do set "Data Connections/Data connections for the form template: >>Chosen Sharepoint (data source) list >> Modify >> chosen location >> to "sort by:" and "sort order (ascending)" and pinpoint to the column that contains the dates, it does not pull the right unique identifyer, but simply the latest date from all the dates available in the column. By the same method, if its set to be sorted by the unique ID, it selects the right under user, but with the first available date there is, not the latest one I'd need. Hope this makes sense.https://www.infopathdev.com:443/forums/thread/124223.aspxMon, 28 Jun 2021 15:16:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124223Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/124223.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124223I would probably query by user, sorted by date desc, and then you know the first returned row is the row you want.https://www.infopathdev.com:443/forums/thread/124219.aspxMon, 28 Jun 2021 07:47:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124219CsabaBekesi0https://www.infopathdev.com:443/forums/thread/124219.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=124219Hello everyone! Thanks for having me. I do have my form connected to a Sharepoint table (my data source). From that table I'd need the form to pull the latest entries of a user. I am stuck at this very point. Either I pull by ID or by date: - if by ID, then I have no clue how to have the form query for the latest date. - if by date, then latest dates getting queried, but not by the ID (mixing up the users). Please see the attached example screenshot (sry for quality). Thanks for the insights. Best, Csaba