Column Permission Profile (mspp_columnpermissionprofile) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Added by: Power Pages Apps Solution
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
BulkRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Create | POST /mspp_columnpermissionprofiles See Create |
CreateRequest or Create |
CreateMultiple | CreateMultipleRequest | |
Delete | DELETE /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid) See Delete |
DeleteRequest or Delete |
PurgeRetainedContent | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Retrieve | GET /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveEntityChanges | RetrieveEntityChangesRequest | |
RetrieveMultiple | GET /mspp_columnpermissionprofiles See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RollbackRetain | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. | |
Update | PATCH /mspp_columnpermissionprofiles(mspp_columnpermissionprofileid) See Update |
UpdateRequest or Update |
UpdateMultiple | UpdateMultipleRequest | |
ValidateRetentionConfig | This message is to be executed only by Dataverse to trigger registered plug-ins and flows. |
Properties
Property | Value |
---|---|
CollectionSchemaName | mspp_columnpermissionprofiles |
DisplayCollectionName | Column Permission Profiles |
DisplayName | Column Permission Profile |
EntitySetName | mspp_columnpermissionprofiles |
IsBPFEntity | False |
LogicalCollectionName | mspp_columnpermissionprofiles |
LogicalName | mspp_columnpermissionprofile |
OwnershipType | OrganizationOwned |
PrimaryIdAttribute | mspp_columnpermissionprofileid |
PrimaryNameAttribute | mspp_profilename |
SchemaName | mspp_columnpermissionprofile |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- mspp_allcolumnpermissions
- mspp_columnpermissionprofileId
- mspp_createdby
- mspp_createdon
- mspp_modifiedby
- mspp_modifiedon
- mspp_profilename
- mspp_tablename
- mspp_websiteid
- statecode
- statuscode
mspp_allcolumnpermissions
Property | Value |
---|---|
Description | |
DisplayName | All Column Permissions |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_allcolumnpermissions |
RequiredLevel | None |
Type | MultiSelectPicklist |
mspp_allcolumnpermissions Choices/Options
Value | Label | Description |
---|---|---|
746610000 | Create | |
746610001 | Read | |
746610002 | Update |
mspp_columnpermissionprofileId
Property | Value |
---|---|
Description | Unique identifier for entity instances |
DisplayName | Column Permission Profile |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | mspp_columnpermissionprofileid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
mspp_createdby
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
mspp_createdon
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was created. |
DisplayName | Created On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_createdon |
RequiredLevel | None |
Type | DateTime |
mspp_modifiedby
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
mspp_modifiedon
Property | Value |
---|---|
DateTimeBehavior | UserLocal |
Description | Shows the date and time when the record was modified. |
DisplayName | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_modifiedon |
RequiredLevel | None |
Type | DateTime |
mspp_profilename
Property | Value |
---|---|
Description | |
DisplayName | Profile Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_profilename |
MaxLength | 400 |
RequiredLevel | ApplicationRequired |
Type | String |
mspp_tablename
Property | Value |
---|---|
Description | |
DisplayName | Table Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_tablename |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
mspp_websiteid
Property | Value |
---|---|
Description | |
DisplayName | Website |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | mspp_websiteid |
RequiredLevel | ApplicationRequired |
Targets | mspp_website |
Type | Lookup |
statecode
Property | Value |
---|---|
Description | Status of the Column Permission Profile |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
statecode Choices/Options
Value | Label | DefaultStatus | InvariantName |
---|---|---|---|
0 | Active | 1 | Active |
1 | Inactive | 2 | Inactive |
statuscode
Property | Value |
---|---|
Description | Reason for the status of the Column Permission Profile |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
statuscode Choices/Options
Value | Label | State |
---|---|---|
1 | Active | 0 |
2 | Inactive | 1 |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- mspp_createdbyName
- mspp_createdbyYomiName
- mspp_modifiedbyName
- mspp_modifiedbyYomiName
- mspp_websiteidName
mspp_createdbyName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_createdbyname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
mspp_createdbyYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_createdbyyominame |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
mspp_modifiedbyName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_modifiedbyname |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
mspp_modifiedbyYomiName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_modifiedbyyominame |
MaxLength | 200 |
RequiredLevel | None |
Type | String |
mspp_websiteidName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | mspp_websiteidname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
One-To-Many Relationships
Listed by SchemaName.
mspp_columnpermission_columnpermissionprofile
Same as the mspp_columnpermission_columnpermissionprofile many-to-one relationship for the mspp_columnpermission table/entity.
Property | Value |
---|---|
ReferencingEntity | mspp_columnpermission |
ReferencingAttribute | mspp_columnpermissionprofileid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | mspp_columnpermission_columnpermissionprofile |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 10000 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
- mspp_columnpermissionprofile_website
- mspp_systemuser_mspp_columnpermissionprofile_createdby
- mspp_systemuser_mspp_columnpermissionprofile_modifiedby
mspp_columnpermissionprofile_website
See the mspp_columnpermissionprofile_website one-to-many relationship for the mspp_website table/entity.
mspp_systemuser_mspp_columnpermissionprofile_createdby
Added by: System Solution Solution
See the mspp_systemuser_mspp_columnpermissionprofile_createdby one-to-many relationship for the systemuser table/entity.
mspp_systemuser_mspp_columnpermissionprofile_modifiedby
Added by: System Solution Solution
See the mspp_systemuser_mspp_columnpermissionprofile_modifiedby one-to-many relationship for the systemuser table/entity.
Many-To-Many Relationships
Relationship details provided where the mspp_columnpermissionprofile table is the first table in the relationship. Listed by SchemaName.
mspp_columnpermissionprofile_webrole
See the mspp_columnpermissionprofile_webrole many-to-many relationship for the mspp_webrole table/entity.
See also
Dataverse table/entity reference
Web API Reference
mspp_columnpermissionprofile EntityType
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for