Knowledge Base

How to convert a Cascaded Lookup column to a SharePoint lookup column?

Cascaded Lookup enables you to create a filtered lookup column to narrow down the retrieved information from different sites in SharePoint. But if you want to convert it to a native SharePoint lookup column, there is a way to get it done for sure.

This article will demonstrate how to convert a Cascaded Lookup column to a native SharePoint lookup column.

WHAT YOU'LL GET

WHAT YOU'LL NEED

The sample data we use for this case

The Product column and the Customer column are both Cascaded Lookup columns in the list.

Convert a Cascaded Lookup column to a SharePoint lookup column

  1. Download the trial version of Cascaded Lookup, and install it to your SharePoint server.

  2. Navigate to the Orders list prepared above, go to the List Settings page, in General Settings section, click Convert Lookup Column (Powered by BoostSolutions) .

  3. In the Convert Lookup Column page, select Cascaded Lookup Columns -> Lookup Columns and select Product and Customer. Then click OK.

  4. In Columns section, you will find that the column type of Product and Customer have been changed to Lookup.

  5. In the Orders list, the values of lookup column will be remained after converting.

Login