根据优先选择列过滤多选列 [英] Filtering a multi-select column based on a prior choice column

问题描述

I am building a new SharePoint list (we use SharePoint online) and in that list I have a lookup to Department.  This also captures the department ID number.  The next field I have is Positions.  I also have a DepartmentalPositions list (separately) that I want to use as a "linking" table that contains the DepartmentNumber and PositionID.  Ultimately what I want is when the department is selected to only display the positions that are linked to that department.  How would I go about doing this?  Eventually this list is also going to be part of a Power App.

感谢，如果我发帖到错误的社区，请告诉我

Thanks and if I am posting to the wrong community, please let me know

Brad Allison

Brad Allison

推荐答案

首先，我永远不会对任何东西使用多重选择.这是一个糟糕的概念，但执行效果较差.永远不要使用它.

First, I would never use multi-select for anything. It's a horrible concept with a worse implementation. Don't use it, ever.

在那之后，建立关系数据架构是一个好主意，但是SharePoint很难使其成为关系数据库引擎.它绝对不是关系数据库，也没有查询引擎.但是有很多黑客 您可以将其合并到应用程序"中以弥补其缺点.

After that, building a relational data schema is a great idea, but SharePoint hardly lends itself to being a relational database engine. It is absolutely NOT a relational database, and it does not have a query engine.  But there are plenty of hacks that you can incorporate into your "Apps" to compensate for its shortcomings.

级联下拉列表已由SPServices(GitHub)和Hillbilly处理. Google两者兼而有之，并找出哪一个可以更好地满足您的需求，尤其是考虑到您想要制作PowerApp的情况. (很难相信，在所有这些时间之后， 像层叠式下拉菜单这样的基本功能，无法进入"PowerApp"之类的声音.听起来更像PowerlessApp.)

Cascading dropdowns have been handled by SPServices (GitHub) and Hillbilly. Google for both, and figure out which one will better serve your needs, especially given your desire to make a PowerApp. (It is hard to believe that after all this time that something as basic as a cascading dropdown can't make it's way into something called "PowerApp". Sounds more like PowerlessApp.)

这篇关于根据优先选择列过滤多选列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！