如果其他领域存在
我使用具有多人或组类型的SharePoint列表创建的PowerApp。 PowerApp的表格允许用户从M365选择给定字段的员工。
问题在于,如果已经分配/选择,我想删除他们。
这是PowerApp的屏幕截图。当前,如果在Window1中选择了一个人,则仍然可以在Window2中选择。我想让该人在Window2中不显示作为选择选项。
另外一个捕获是SharePoint列表允许启用多个选择。非常感谢任何指导/建议来解决这一问题。
I have a PowerApp created using SharePoint list with multiple Person or Group type. The PowerApp has a form that allows user to select employees from M365 for a given field.
The problem is that I would like to remove person if they are already assigned/select.
This is a screenshot of the powerapp. Currently if a person is selected in Window1 they are still available to select in Window2. I would like to have that person not show as a selection option in Window2.
One additional catch is that the SharePoint list has Allow multiple selections enabled. Greatly appreciate any guidance/advice to solve this one.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
窗口1:
onChange -set(window1SelectedItem,self.selected.value);
项目 - 过滤器(项目,值<> window2SelectedItem,value< window3SelectedItem,value<> window4SelectedItem,value<> window5selectedItem);
窗口2:
onChange -set(window2SelectedItem,self.selected.value);
项目 - 过滤器(项目,值<> window1SelectedItem,value< window3SelectedItem,value<> window4SelectedItem,value<> window5selectedItem);
窗口3:
onChange -set(window3SelectedItem,self.selected.value);
项目 - 过滤器(项目,值<> window1SelectedItem,value< window2SelectedItem,value<> window4SelectedItem,value<> window5selectedItem);
窗口4:
onChange -set(window4SelectedItem,self.selected.value);
项目 - 过滤器(项目,值<> window1SelectedItem,value<> window2selectedItem,value<> window3SelectedItem,value<> window5selectedItem);
窗口5:
onChange -set(window5SelectedItem,self.selected.value);
项目 - 过滤器(项目,值<> window1SelectedItem,value<> window2SelectedItem,value<> window3SelectedItem,value<> window4selectedItem);
如果此答案有帮助,请随时接受它作为正确的答案。
Window 1:
Onchange - Set(window1SelectedItem, Self.Selected.Value);
Items - Filter(items, Value <> window2SelectedItem, Value <> window3SelectedItem, Value <> window4SelectedItem, Value <> window5SelectedItem);
Window 2:
Onchange - Set(window2SelectedItem, Self.Selected.Value);
Items - Filter(items, Value <> window1SelectedItem, Value <> window3SelectedItem, Value <> window4SelectedItem, Value <> window5SelectedItem);
Window 3:
Onchange - Set(window3SelectedItem, Self.Selected.Value);
Items - Filter(items, Value <> window1SelectedItem, Value <> window2SelectedItem, Value <> window4SelectedItem, Value <> window5SelectedItem);
Window 4:
Onchange - Set(window4SelectedItem, Self.Selected.Value);
Items - Filter(items, Value <> window1SelectedItem, Value <> window2SelectedItem, Value <> window3SelectedItem, Value <> window5SelectedItem);
Window 5:
Onchange - Set(window5SelectedItem, Self.Selected.Value);
Items - Filter(items, Value <> window1SelectedItem, Value <> window2SelectedItem, Value <> window3SelectedItem, Value <> window4SelectedItem);
if this answer is helpful feel free to accept it as a correct answer.