Steps to Implement Cascading Drop Down. Follow the steps in SharePoint UI. (Browser)


Steps to Implement Cascading Drop Down. Follow the steps in SharePoint UI. (Browser)
  • Create a custom List Name it as City List. and Rename Title as City, Insert two items into it.
  • Create a Custom List name it as District list and rename Title as District, Create a Column by Name City, of type look up. Get information from City List , City Column. And few items with corresponding to city column.
  • Create a Region List name it as Region list and rename Title as Region, Create a Column by Name City, of type look up. Get information from City List , City Column. And Create a Column by Name District, of type look up. Get information from District List, District Column.
  • Now in Region List, From the Ribbon Click on List Tools. Click on customize form .Form template will be imported to InfoPath.
  • Right Click on District Dropdown, Select Dropdown List box Properties, Select Get choices from external data then Add Data Source Click on Next.
  • Select List and Library and Click on Next. and Enter your web site url and click on Next
  • Select District List and Click on Next and Check on City, District and ID. Make sure that Sort by ID is enabled
  • Click on Next. And again click on Next and Finish. It Creates a Datasource1
  • Again in Dropdown list box properties at Entries click on Select XPath.   And click Filter Data.
  • In Filter data Dialog, Click on Add it opens Specify filter Conditions dialog.
  • In the first dropdown select “Select a field or group”. Now a select a City Field from District list 1 (Data source). Click on OK.
  • In the third dropdown select “Select a field or group”. Now a select a City Field from Main (Data source). Click on OK.
  • In the filter data dialog you will have condition as City = City. Click on OK
  • In Drop Down List box properties, choose d:ID in Value - section.
  • In Drop Down List box properties, choose d:Title in Display Name -  section then click OK to close 
Note: d:Id and d:Title( Region Column) can be selected from their corresponding  Select XPath button .

Click on quick publish to publish form in SharePoint 

Comments

Post a Comment

Popular posts from this blog

[Solved ] ...The product key entered does not match any of the Windows images available for installation. Enter a different product key

Step by step process to Make Pen drive as Bootable.    Enter into CMD Prompt.    Type - DISKPART.    Type - List DISK. Once we enter here it will list USB Disk Number. If your USB Disk Number is 1. Then Execute following Commands.    Select DISK 1    C lean    Create Partition Primary    Select Partition 1    Active    Format FS=NTFS Quick    Assign     Exit. Now insert DVD into DVD-Rom and Copy complete content of DVD into Removable Drive (Pen drive). Common Error for Windows 8 Based Computers. The product key entered does not match any of the Windows images available for installation. Enter a different product key. Please follow these steps to solve this error. Step -1 Create a file PID.TXT with following structure. Step -2 [PID] Value=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX Step – 3 Place your windows 8/2012 Pro key in where the X's are and save the file to the /sources directory in the Bootable USB Drive .
Read more

SharePoint Search Service application content sources showing Paused

There may be many reasons for content sources to get into Paused  Below PowerShell script will help you c hecks status of Search Service application whether its running or Paused. If paused then returns the detailed information why its paused and asks input from user to resume  asnp "*sharepoint*" $searchserviceapps = Get-SPEnterpriseSearchServiceApplication foreach ($ssa in $searchserviceapps) {  Write-Host $ssa  -ForegroundColor Magenta $band = "0x" $band0 = "0x0" Function Details()     { $Detail = Read-Host "Do you want to see detailed reasons (Y/N) " If($Detail -eq "y")         { Write-Host " (band 0x01)          A change in the number of crawl components or crawl databases is in progress. (band 0x02)          A backup or restore procedure is in progress. (band 0x04)          A backup of the Volume Shadow Copy Service (VSS) is in progress. (band 0x08)          
Read more

User Profile Synchronization Service Struck on "Starting" - Fixed

Image
User profile Service Synchronization  service Struck on “ starting ” . In SharePoint 2010 it is very common problem that whenever user profile synchronization is started. It gets struck on “starting”. There were many cases where user profile synchronization struck on starting  from my experience I will list some cases. First stop user profile synchronization service by using SharePoint Management Shell. ·          Get-SpServiceInstance ·          It will list all services currently running on SharePoint Farm.           ·          Select Id of User profile service synchronization, you can select Id by Right click on command prompt now Mark ID of User profile service synchronization and Hit Enter , Now Id will be automatically copied. ·          Now, stop user profile synchronization service . ·          Stop-SpServiceInstance –ID  <User profile synchronization service -ID > ·          You will be prompted with yes or no. Enter “ Y” to confirm your
Read more