Home

Way to filter column data based on Creator

%3CLINGO-SUB%20id%3D%22lingo-sub-1259431%22%20slang%3D%22en-US%22%3EWay%20to%20filter%20column%20data%20based%20on%20Creator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1259431%22%20slang%3D%22en-US%22%3E%3CP%3EConcept%3A%3C%2FP%3E%3CUL%3E%3CLI%3EI%20have%20a%20list%20that%20different%20users%20are%20creating%20Reference%20numbers.%3C%2FLI%3E%3CLI%3EFrom%20another%20list%20that%20is%20used%20to%20generate%20Documents%2C%20users%20are%20selecting%20a%20Reference%20number%20that%20they%20want%20to%20use%20in%20this%20Document%20from%20a%20Drop-Down(using%20Look%20Up)%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20want%20those%20users%20to%20have%20in%20the%20Drop-Down%20only%20the%20reference%20numbers%20that%20%3CU%3Ethey%20created%3C%2FU%3E!%20(Each%20user%20their%20Reference%20Numbers)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anyway%20that%20I%20can%20achieve%20this%3F%3C%2FP%3E%3CP%3E(SharePoint%20Online)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E(I%20know%20that%20I%20can't%20use%20%5BMe%5D%20in%20a%20calculated%20column.)%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1259431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262027%22%20slang%3D%22en-US%22%3ERe%3A%20Way%20to%20filter%20column%20data%20based%20on%20Creator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262027%22%20slang%3D%22en-US%22%3EYou%20would%20need%20to%20customise%20the%20list%20form%20using%20PowerApps%20to%20filter%20the%20values%20from%20the%20reference%20number%20list.%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps%2FFilter-SharePoint-list-on-Current-User%2Ftd-p%2F13945%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FBuilding-Power-Apps%2FFilter-SharePoint-list-on-Current-User%2Ftd-p%2F13945%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Concept:

  • I have a list that different users are creating Reference numbers.
  • From another list that is used to generate Documents, users are selecting a Reference number that they want to use in this Document from a Drop-Down(using Look Up)

I want those users to have in the Drop-Down only the reference numbers that they created! (Each user their Reference Numbers)

 

Is there anyway that I can achieve this?

(SharePoint Online)

 

(I know that I can't use [Me] in a calculated column.)

1 Reply
Highlighted
You would need to customise the list form using PowerApps to filter the values from the reference number list.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-SharePoint-list-on-Current-User/td-p/...