Update restriction on specific columns

Looking for guidance on how to put the restriction in table/columns in a manner that during update only specific defined column are allowed for update during update event that respective row.

Solved Solved
0 3 295
1 ACCEPTED SOLUTION

Use this expression with Editable_If property of the columns you want to restrict editing after the record is initially created. For the columns that you want to allow editing, you don’t need to set any expression.

NOT(IN([Key], TableName[Key]))

View solution in original post

3 REPLIES 3

Use this expression with Editable_If property of the columns you want to restrict editing after the record is initially created. For the columns that you want to allow editing, you don’t need to set any expression.

NOT(IN([Key], TableName[Key]))

Thanks for the quick help @LeventK

You’re welcome.

Top Labels in this Space