Where is the xml (form data) file stored for an item.
The situation is , I have many records and one of the control in the form was not connected to a field. Now I need to get that control data without opening each from.
How can I loop through the form data of all the items? The list workflow can only get the form data for a single item.
Solved! Go to Solution.
I'm not getting your scenario exactly. You can have a loot at this,. Getting XML Data From a SharePoint List – The Easy Way | Kirk Evans Blog
So this is something I have experienced myself, recently.
You need to get "Form Data" -- you'll see it's an Item Property. It's stored as an XML block, so if you use the "Query XML" action, you'll be able to get what you need out of it. This'll be done in your list workflow.
Some things, though...
For the second part, which is to update all of those items... here's how I did it:
Let me know if you have questions. Not sure what you're familiar with!
I know i can take it from a single item using list workflow, but I want loop through all the list item and get the form data to extract a control value and update the list item.
Yes, that's what the second part is - it calls the first workflow (the list workflow) on each ID that you pull into the collection. Then, it runs the workflow on each of them and gets the data out.