Forum Discussion
SharePoint List Column Conditions
Hi,
I'm wanting to select data from Column A, that gives me a predefined list in Column B. (without showing all options as they may not apply.)
Example:
Column A - Hardware = Column B - PC / Laptop / Server
Column A - Software = Column B - Word / Outlook / Excel
Any tips on FUNCTIONS to achieve this this are welcome.
Thanks,
6 Replies
Hi!
my advice: Create only one text column. Then create a PowerApp within your SharePoint LIst. There you can create these cascaded dropdowns! For this to do, click on your list settings, forms settings, let powerapps guide you through a list form. Within that edit screen you can set a field with dropdowns, binded to your text column created in first step.
Hope that helps. Greets, Eva.
Hi David Noble! I would suggest additionally creating 1 Master list. Column 1 is a source for your hardware entries, column 2 is another source for your software to be defined.
Then you go back to your Detailed list and create 2 lookup columns, one for HW and the second for SW. HW is a lookup for column 1 in your Master list. SW is a lookup for column 2 in your master list. Greets, Eva.
Hi Eva Vogel thank you for you reply.
I'm thinking on the lines of this.
If I select either Hardware or Software in Column A. Then Column B will show either Hardware items (PC, Server) or Software items (Word, Excel) depending on what was selected in Column A.
Hi David Noble ! You can make that with only one lookup column and an additional calculated column which refers on chosen lookup items with "IF" Function. If someone chooses an item which is Excel or Word or PowerPoint from lookup list, then its "Software" as text result in your active list, else its "Hardware" (text result). Could be that way.
Greets, Eva.
