InfoPath Dev

Hello 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

I would probably query by user, sorted by date desc, and then you know the first returned row is the row you want.

Thanks 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.

the screenshot attached indicates what I was trying to refer to.

When 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. :)