Forum Discussion
SharePoint List Column Conditions
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.
Hi Eva Vogel could you give me an example IF formula?
Hi David Noble ! I found a very good tutorial for you and created on my own with a sharepoint list and 2 Columns. First is for defining HW or SW, second column are the Assets with HW or SW...
Shane Young gave a good intro for cascaded dropdowns in powerapps on this: https://www.youtube.com/watch?v=pkZG2boN7jQ
Pls. see also my screenshots, what i did and what results shown in this list. I didn´t make more filtering beyond other data. But it fits what you desired i guess. And then you can explore on your own. Greets, Eva.
