You’re offline. This is a read only version of the page.
89
Hello,
In Update Property of multiselect people picker field I'm merging two join user collection join but how i can remove the collection of users from combobox of multiselect people picker field.
The formula of merging two user join in Update Property is like below
Share
ReportUngroup(
Table(
{Items: CollParticipantCurrUser},
{Items: CollParticipantAddUser
}
),
"Items"
)
Hi @REENASH :
Do you want to remove users selected by combo box from this table?
All responses (
Answers (
Ungroup(
Table(
{Items: CollParticipantCurrUser},
{Items: CollParticipantAddUser
}
),
"Items"
)If so ,I assume there is an 'Email' column in 'CollParticipantCurrUser' and CollParticipantAddUser.
You could try:
Filter(
Ungroup(
Table(
{Items: CollParticipantCurrUser},
{Items: CollParticipantAddUser
}
),
"Items"
),
!(Email in TheComboBox.SelectedItems.Email)
)
Best Regards,
Bof
