如果其他领域存在

发布于 2025-01-18 02:40:17 字数 408 浏览 5 评论 0原文

我使用具有多人或组类型的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.

enter image description here

One additional catch is that the SharePoint list has Allow multiple selections enabled. Greatly appreciate any guidance/advice to solve this one.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

因为看清所以看轻 2025-01-25 02:40:17

窗口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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文