Forum Discussion
SharePoint List Column Conditions
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.
