Does a SharePoint list allow you to filter fields when adding in a new item?

%3CLINGO-SUB%20id%3D%22lingo-sub-2802331%22%20slang%3D%22en-US%22%3EDoes%20a%20SharePoint%20list%20allow%20you%20to%20filter%20fields%20when%20adding%20in%20a%20new%20item%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802331%22%20slang%3D%22en-US%22%3E%3CP%3EBasically%20I%20am%20creating%20a%20risk%20assessment%20register%20that%20will%20hold%20items%20regard%20ALL%20risks%20so%20ones%20relating%20to%20fire%2C%20chemicals%2C%20manual%20handling%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EObviously%20these%20types%20of%20risks%20have%20different%20information%20associated%20with%20them%20for%20instances%2C%20chemicals%20have%20%22substance%20type%22%20where%20as%20a%20fire%20hazard%20might%20have%20a%20specific%20%22location%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20add%20a%20new%20item%20into%20a%20SharePoint%20list%2C%20all%20of%20the%20options%20appear%20for%20you%20to%20add%20the%20information%20in%20but%20I%20was%20wondering%20if%20there%20was%20a%20way%20to%20have%20it%20so%20that%20when%20I%20go%20to%20add%20an%20item%20that%20is%20related%20to%20chemical%2C%20only%20the%20boxes%20relating%20to%20chemical%20risk%20assessments%20appear%20instead%20of%20having%20a%20load%20of%20useless%20fields%20for%20the%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20keen%20to%20keep%20this%20as%20one%20list%20as%20a%20central%20register%20that%20users%20can%20filter%20will%20be%20best.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20ideas%20you%20come%20up%20with.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2802331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2802709%22%20slang%3D%22en-US%22%3ERe%3A%20Does%20a%20SharePoint%20list%20allow%20you%20to%20filter%20fields%20when%20adding%20in%20a%20new%20item%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120094%22%20target%3D%22_blank%22%3E%40LukeJSmith%3C%2FA%3E%26nbsp%3Byou%20can%20do%20this%20with%20a%20Power%20Apps%20customised%20form.%20You%20would%20add%20a%20dropdown%20and%20based%20on%20the%20selection%20set%20the%20visibility%20of%20each%20of%20the%20columns%20to%20either%20true%20or%20false.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Basically I am creating a risk assessment register that will hold items regard ALL risks so ones relating to fire, chemicals, manual handling etc.

 

Obviously these types of risks have different information associated with them for instances, chemicals have "substance type" where as a fire hazard might have a specific "location". 

 

When you add a new item into a SharePoint list, all of the options appear for you to add the information in but I was wondering if there was a way to have it so that when I go to add an item that is related to chemical, only the boxes relating to chemical risk assessments appear instead of having a load of useless fields for the user.

 

I am keen to keep this as one list as a central register that users can filter will be best.

 

Thank you for any ideas you come up with. 

1 Reply

@LukeJSmith you can do this with a Power Apps customised form. You would add a dropdown and based on the selection set the visibility of each of the columns to either true or false.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)