Power Platform Community Forum Thread Details

Hello all,

I am looking to set up some unique value rules for a SharePoint list. I know the basic way in the column settings to enforce unique values, but I am looking to do something with a little more complexity. I would like to be able to enforce unique values for every user EXCEPT those that are put into a specified permission group in SharePoint. Currently, I have the list set up so that the enforce unique values setting is applied to the user email column. This is to prevent users from being able to put in more than one item under their own email. However, my organization will have a small number of people that do need to be able to create multiple items under their own email, hence the special permission group.

I also am making a Power App for this list to make the input process a little more user friendly and appealing. So, if there is not a way to do this on the SharePoint side, would it be possible on the Power Apps side?

Any feedback is appreciated.

Categories:

General Questions

I have found this blog that seems to have part of the solution I'm looking for, but when I try to plug in the formula myself, it doesn't want to work. If anyone would be able to tell me if this formula is correct or not for even just the enforcing unique values portion, then might be able to go from there and figure out what I'm doing wrong. If there is a way to get this to work, then I would still need a way of excluding the permission group from the original question. Site linked below but also pasted the formula for easier viewing.

If(IsBlank(LookUp(Employee, Email=DataCardValue17.Text)),
 SubmitForm(EditForm1),
 Notify("Email must be unique",NotificationType.Error);
 SetFocus(DataCardValue17)
)

Power Apps Guide - Data - How to enforce unique values (or prevent duplicate values) in one or more columns - Power Apps Guide - Blog