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 292
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