June 19, 2011

// // Leave a Comment

Cascading update in Infopath form using XML data


We often come across with the requirement to do dynamic update. Since SharePoint is new. I worked a lot on finding this solution. Here we go simple steps for this….
Step one:

Create a XML file like in this format …

               
<?xml version="1.0" encoding="UTF-8"?>
<Data>
                <Country value="India">
                                <State value="Tamil Nadu"/>
                                <State value="Andhra Pradesh"/>
                                <State value="Kerala"/>
                </Country>
                <Country value="Srilanka">
                                <State value="Western Province"/>
                                <State value="Eastern Province"/>
                </Country>
</Data>
                               
                               
 Step 2:
Open InfoPath form and create the Country and State dropdown list boxes.








Step 3:
Add the xml data which we created from the InfoPath form.









Step 4:
Give the xml data name and click finish …





















Step 5:
Right click list box of country and go to properties



























Step 6:
Select the xml data source and Select the Country as value.
















































Step 7:
Similarly go to state properties and click to add the xml data and filter data to country ….



Step 8:
And now click preview to see the changes…




























0 comments:

Post a Comment