Custom Views Question

%3CLINGO-SUB%20id%3D%22lingo-sub-974844%22%20slang%3D%22en-US%22%3ECustom%20Views%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-974844%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20clerical%20professional%20working%20for%20Child%20Protective%20Services%20in%20my%20local%20county%20government.%20I'm%20the%20list%20administrator%20for%20our%20SharePoint%20list%20where%20we%20store%20data%20pertaining%20to%20all%20of%20the%20services%20we%20provide%20children.%20Since%20taking%20over%20the%20list%20I've%20expanded%20how%20we%20run%20reports%20and%20created%20custom%20views%20but%20I'm%20reaching%20the%20point%20where%20I%20want%20to%20do%20things%20that%20seem%20too%20complex%20for%20custom%20views.%20I'm%20hoping%20to%20at%20least%20get%20some%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20custom%20view%20that%20extracts%20only%20information%20in%20a%20single%26nbsp%3Bcolumn%20that%20contains%26nbsp%3Ba%20duplicate%20value%20(which%20identifies%20which%20child%20welfare%20case%20the%20services%20are%20linked%20to).%20I'm%20not%20given%20any%20option%20for%20duplicate%20values%20and%20I'm%20hoping%20there's%20a%20way%20I%20can%20do%20it%20without%20having%20to%20export%20to%20Excel%20and%20work%20from%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%20would%20be%20appreciated%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3EDom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-974844%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-975188%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20Views%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-975188%22%20slang%3D%22en-US%22%3EHi%20Dom%2C%3CBR%20%2F%3EQuick%20question%3A%20are%20you%20enforcing%20at%20the%20column%20level%20to%20have%20unique%20values%3F%20That%20could%20be%20a%20solution%20for%20your%20use%20case%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello community,

 

I'm a clerical professional working for Child Protective Services in my local county government. I'm the list administrator for our SharePoint list where we store data pertaining to all of the services we provide children. Since taking over the list I've expanded how we run reports and created custom views but I'm reaching the point where I want to do things that seem too complex for custom views. I'm hoping to at least get some suggestions.

 

I'm trying to create a custom view that extracts only information in a single column that contains a duplicate value (which identifies which child welfare case the services are linked to). I'm not given any option for duplicate values and I'm hoping there's a way I can do it without having to export to Excel and work from there.

 

Any suggestions would be appreciated,

 

Thank you,

Dom

2 Replies
Highlighted
Hi Dom,
Quick question: are you enforcing at the column level to have unique values? That could be a solution for your use case
Highlighted
Think the duplicate is on purpose. What might work is grouping on that column? Then you’ll be able to see but over time if this is a large list groups don’t work properly. Only place I would go is either using flow to do a check if another exists when it’s create or modified and check another column or box “has case” or something like that.

Or powerapps could be used here to create some good views based on all kinds of logic but there is a larger learning curve here.