Solved: Add and update for different groups - Page 2

Fernanda_Lopez · 07-23-2020 10:35 AM

Hi
I want to make a group of people be able to add in a view and another group of people just be able to make updates with an action in the same view (I dont want them to be ablet to add)
What do I have to do?

LeventK

SELECT() expression returns a List where SWITCH() expression expects a single value. Wrap your SELECT expression with ANY(SELECT(…)) and ensure that the expression will return an email value as you are evaluating the USEREMAIL() expression’s return value.

Provided you need to evaluate if the USEREMAIL() lies in the List of Selected Values then you need to use an IFS()/IF() and IN() expressions:

IF(
    IN(USEREMAIL(), SELECT(TableName[ColumnName], {Yes/No Condition})),
    "ALL_CHANGES",
    "UPDATES_ONLY"
)

View solution in original post