@EricC
On the Submit button, give a try with following formula:
Clear(colCommonUsers);
ForAll(
drpMembers.SelectedItems,
If(
DisplayName in drpOwners.SelectedItems.DisplayName,
Collect(
colCommonUsers,
DisplayName
)
)
);
If(
!IsEmpty(colCommonUsers),
Set(
varCommonUserDisplayFlag,
true
);
Set(
varCommonUser,
Concat(
colCommonUsers,Value,
";"
)
),
SubmitForm(<SharePointListDataSource>)
)
Please a label on the form and name its properties as below:
Text: "The user " & varCommonUser & " exists in both Owners and Members fields. You can add a user either in Owners or Members field."
Visible: varCommonUserDisplayFlag
On visibility of the screen, set following two variables as below:
Set(varCommonUserDisplayFlag, false);
Set(varCommonUser, blank())
Regards
Krishna Rachakonda
| If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone. |
