SharePoint list - Filter a field in form based on another field when adding a new element

%3CLINGO-SUB%20id%3D%22lingo-sub-2727905%22%20slang%3D%22en-US%22%3ESharePoint%20list%20-%20Filter%20a%20field%20in%20form%20based%20on%20another%20field%20when%20adding%20a%20new%20element%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727905%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20SharePoint%20list%20that%20I%20use%20as%20a%20simple%20ticketing%20system.%20In%20that%20list%20I%20have%20I%20need%20the%20values%20of%20one%20column%20to%20be%20filtered%20based%20on%20another%20column%20when%20I%20add%20a%20new%20item%20%2F%20row.%3C%2FP%3E%3CP%3EPreviously%20this%20was%20done%20using%20an%20infopath%20form%20but%20because%20compatibility%20it%20is%20no%20longer%20an%20option%20and%20using%20PowerApps%20neither.%3C%2FP%3E%3CP%3EAs%20an%20example%2C%20I%20currently%20have%20a%20list%20in%20this%20format%20with%20theys%20keys%3A%3C%2FP%3E%3CP%3EArea1%20-%20Product%201%3CBR%20%2F%3EArea1%20-%20Product%202%3CBR%20%2F%3EArea1%20-%20Product%203%3C%2FP%3E%3CP%3EArea2%20-%20Product%204%3CBR%20%2F%3EArea3%20-%20Product%205%3CBR%20%2F%3EArea3%20-%20Product%206%3C%2FP%3E%3CP%3EI%20need%20that%2C%20in%20another%20list%2C%20when%20a%20user%20adds%20a%20new%20element%20in%20the%20list%20and%20in%20a%20option%20field%20%2F%20column%20of%20the%20form%20selects%20%22Area1%22%26nbsp%3B%20in%20another%20field%20only%20the%20options%20%22Product%201%2C%20Product%202%20and%20Product%203%22%20appear.%3C%2FP%3E%3CP%3ERight%20now%20this%20list%20use%20a%20look%20up%20column%20to%20one%20with%20the%20keys%20but%20I%20fail%20trying%20to%20configure%20de%20%22product%20part%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyione%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2727905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I have a SharePoint list that I use as a simple ticketing system. In that list I have I need the values of one column to be filtered based on another column when I add a new item / row.

Previously this was done using an infopath form but because compatibility it is no longer an option and using PowerApps neither.

As an example, I currently have a list in this format with theys keys:

Area1 - Product 1
Area1 - Product 2
Area1 - Product 3

Area2 - Product 4
Area3 - Product 5
Area3 - Product 6

I need that, in another list, when a user adds a new element in the list and in a option field / column of the form selects "Area1"  in another field only the options "Product 1, Product 2 and Product 3" appear.

Right now this list use a look up column to one with the keys but I fail trying to configure de "product part".

 

Could anyione help me?

 

Thank you.

0 Replies