Sharepoint LookUp Column Advice

%3CLINGO-SUB%20id%3D%22lingo-sub-1106809%22%20slang%3D%22en-US%22%3ESharepoint%20LookUp%20Column%20Advice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1106809%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20hoping%20someone%20can%20point%20me%20in%20the%20right%20direction.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%26nbsp%3B%20have%20the%20following%202%20SharePoint%20Lists%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EPostcode%20Uplift%20(2%20columns)%20-%20this%20contains%20575747%20postcodes%20in%20Column%20-%20Postcodes%2C%20and%20their%20corresponding%20Uplift%20factors%20within%20Column%20-%20Uplift%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ELearner%20Lists%20-%20I%20use%20an%20Excel%20Table%20to%20upload%20learner%20information%20to%20this%20list%20which%20includes%20postcode.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI'd%20like%20to%20link%20the%20Learner%20List%20so%20that%20when%20I%20upload%20a%20learner%2C%20an%20Uplift%20column%20is%20automatically%20filled%20with%20the%20corresponding%20Uplift%20Factor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20managed%20to%20create%20the%20link%20via%20a%20Postcode%20column%20in%20Learner%20List%20set%20as%20a%20LookUp%2C%20however%20-%20I%20can't%20then%20manually%20add%20postcodes%2C%20or%20use%20a%20flow%20to%20upload%20the%20data%2C%20as%20I%20then%20appear%20to%20have%20to%20select%20the%20postcode%20from%20a%20drop%20down%20list%20when%20entering%20a%20new%20learner%20onto%20the%20learner%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20there%20are%20so%20many%20postcodes%20to%20search%2C%20this%20would%20take%20too%20much%20time%20to%20have%20to%20scroll%20to%20find%20the%20correct%20postcode.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20of%20uploading%20the%20learner%20to%20the%20List%20%26amp%3B%20then%20for%20the%20Uplift%20column%20to%20complete%20the%20Uplift%20Factor%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3CP%3ELisa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1106809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELookup%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

I'm hoping someone can point me in the right direction.

 

I  have the following 2 SharePoint Lists:

 

  • Postcode Uplift (2 columns) - this contains 575747 postcodes in Column - Postcodes, and their corresponding Uplift factors within Column - Uplift 

 

  • Learner Lists - I use an Excel Table to upload learner information to this list which includes postcode.

I'd like to link the Learner List so that when I upload a learner, an Uplift column is automatically filled with the corresponding Uplift Factor.

 

I've managed to create the link via a Postcode column in Learner List set as a LookUp, however - I can't then manually add postcodes, or use a flow to upload the data, as I then appear to have to select the postcode from a drop down list when entering a new learner onto the learner list.

 

As there are so many postcodes to search, this would take too much time to have to scroll to find the correct postcode.

 

Is there a way of uploading the learner to the List & then for the Uplift column to complete the Uplift Factor?

 

Thank you 

Lisa

0 Replies