InfoPath Dev

Do these functions only update the last list item? Can I not update the entire list from a repeating table or could I be doing something wrong? I'm using /mode=Update in the RefreshSharePointListItems cmd.

I'm going to bet that your mapping isn't specifying a repeating group. Feel free to attach your mapping.xml if you'd like me to take a look.

Your response totally lit the lightbulb off for me. The fields are in a repeating table but the ID field is not. Long story short, I have the ID field in a different group (non-repeating) as I needed the columns to match a previous table the data was copied from before submitting it to my SP list. If I move that ID field to its own repeating table, I assume that should solve my problem. Does that sound right to you?

If you are mapping a repeating group and want to link your form items to your list (including being able to refresh), the mapping needs to indicate the repeating group and the id field needs to be in the repeating group. On submit, the code will use that ID for updating existing items and if it is blank will add new items. On refresh, the id is used to return the data for the item from the list. Does that make sense?

I think so. So you're saying I need to have the id field in the same repeating group as the rest of the data? It's not enough that I am going to put the id field is in a seperate repeating group?

They have to go in the same repeating group. If you need to set them to existing values in order to update existing items, you can use other form logic.

Cool. Thanks again for your help Hilary!