Social Profile (SocialProfile) table/entity reference (Microsoft Dataverse) - Power Apps

Artigo
11/09/2024

This entity is used to store social profile information of its associated account and contacts on different social channels.

Messages

The following table lists the messages for the Social Profile (SocialProfile) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Assign` Event: True	`PATCH` /socialprofiles(socialprofileid) Update the `ownerid` property.	AssignRequest
`Create` Event: True	`POST` /socialprofiles See Create	Create records
`Delete` Event: True	`DELETE` /socialprofiles(socialprofileid) See Delete	Delete records
`GenerateSocialProfile` Event: True	GenerateSocialProfile	GenerateSocialProfileRequest
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`Retrieve` Event: True	`GET` /socialprofiles(socialprofileid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /socialprofiles See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`SetState` Event: True	`PATCH` /socialprofiles(socialprofileid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /socialprofiles(socialprofileid) See Update	Update records
`Upsert` Event: False	`PATCH` /socialprofiles(socialprofileid) See Upsert a table row	UpsertRequest

Properties

The following table lists selected properties for the Social Profile (SocialProfile) table.

Property	Value
DisplayName	Social Profile
DisplayCollectionName	Social Profiles
SchemaName	`SocialProfile`
CollectionSchemaName	`SocialProfiles`
EntitySetName	`socialprofiles`
LogicalName	`socialprofile`
LogicalCollectionName	`socialprofiles`
PrimaryIdAttribute	`socialprofileid`
PrimaryNameAttribute	`profilename`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

Blocked
Community
CustomerId
CustomerIdName
CustomerIdType
CustomerIdYomiName
ImportSequenceNumber
InfluenceScore
OverriddenCreatedOn
OwnerId
OwnerIdName
OwnerIdType
ProfileFullName
ProfileLink
ProfileName
SocialProfileId
StateCode
StatusCode
TimeZoneRuleVersionNumber
TransactionCurrencyId
UniqueProfileID
UTCConversionTimeZoneCode

Blocked

Property	Value
Description	Identifies if the social profile has been blocked.
DisplayName	Blocked
IsValidForForm	True
IsValidForRead	True
LogicalName	`blocked`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`socialprofile_isblocked`
DefaultValue	False
True Label	Yes
False Label	No

Community

Property	Value
Description	Identifies where the social profile originated from, such as Twitter, or Facebook.
DisplayName	Social Channel
IsValidForForm	True
IsValidForRead	True
LogicalName	`community`
RequiredLevel	None
Type	Picklist
DefaultFormValue	0
GlobalChoiceName	`socialprofile_community`

Community Choices/Options

Value	Label
0	Other
1	Facebook
2	Twitter

CustomerId

Property	Value
Description	Shows the customer that this social profile belongs to.
DisplayName	Customer
IsValidForForm	True
IsValidForRead	True
LogicalName	`customerid`
RequiredLevel	None
Type	Customer
Targets	account, contact

CustomerIdName

Property	Value
Description	Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities.
DisplayName	Parent Customer Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`customeridname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

CustomerIdType

Property	Value
Description	Select the parent account or parent contact for the contact
DisplayName	Parent Customer Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`customeridtype`
RequiredLevel	None
Type	EntityName

CustomerIdYomiName

Property	Value
Description	Select the parent account or parent contact for the contact
DisplayName	Parent Customer Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`customeridyominame`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	450

ImportSequenceNumber

Property	Value
Description	Unique identifier of the data import or data migration that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

InfluenceScore

Property	Value
Description	Shows the score that determines the online social influence of the social profile.
DisplayName	Influence Score
IsValidForForm	True
IsValidForRead	True
LogicalName	`influencescore`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	1000000000
MinValue	0
Precision	2

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

OwnerId

Property	Value
Description	Shows the user or team that is assigned to manage the record. This field is updated every time the record is assigned to a different user.
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdName

Property	Value
Description	Name of the owner
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridname`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdType

Property	Value
Description	Owner Id Type
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

ProfileFullName

Property	Value
Description	Shows the display name of the customer on this social profile.
DisplayName	Full Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`profilefullname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	160

ProfileLink

Property	Value
Description	Shows the customer that this social profile belongs to.
DisplayName	Profile Link
IsValidForForm	True
IsValidForRead	True
LogicalName	`profilelink`
RequiredLevel	None
Type	String
Format	Url
FormatName	Url
ImeMode	Auto
IsLocalizable	False
MaxLength	100

ProfileName

Property	Value
Description	Shows the name of the social profile on the corresponding social channel.
DisplayName	Profile Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`profilename`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

SocialProfileId

Property	Value
Description	Unique Identifier of the social profile name.
DisplayName	Social Profile ID
IsValidForForm	False
IsValidForRead	True
LogicalName	`socialprofileid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

StateCode

Property	Value
Description	Status of the Social Profile
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`socialprofile_statecode`

StateCode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 2 InvariantName: `Inactive`

StatusCode

Property	Value
Description	Reason for the status of the Social Profile
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue	-1
GlobalChoiceName	`socialprofile_statuscode`

StatusCode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	`transactioncurrencyid`
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

UniqueProfileID

Property	Value
Description	Unique ID of the Profile ID
DisplayName	Unique Profile ID
IsValidForForm	True
IsValidForRead	True
LogicalName	`uniqueprofileid`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the record was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`exchangerate`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who modified the record.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OwnerIdYomiName

Property	Value
Description	Yomi name of the owner
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridyominame`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Unique identifier for the business unit that owns the record
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier of the team who owns the contact.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier of the user who owns the contact.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

VersionNumber

Property	Value
Description	Version number of the social profile.
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

business_unit_socialprofiles
lk_SocialProfile_createdonbehalfby
lk_SocialProfile_modifiedonbehalfby
owner_SocialProfile
Socialprofile_customer_accounts
Socialprofile_customer_contacts
socialProfile_owning_user
transactioncurrency_SocialProfile

business_unit_socialprofiles

One-To-Many Relationship: businessunit business_unit_socialprofiles

Property	Value
ReferencedEntity	`businessunit`
ReferencedAttribute	`businessunitid`
ReferencingAttribute	`owningbusinessunit`
ReferencingEntityNavigationPropertyName	`owningbusinessunit`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_SocialProfile_createdonbehalfby

One-To-Many Relationship: systemuser lk_SocialProfile_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_SocialProfile_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_SocialProfile_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

owner_SocialProfile

One-To-Many Relationship: owner owner_SocialProfile

Property	Value
ReferencedEntity	`owner`
ReferencedAttribute	`ownerid`
ReferencingAttribute	`ownerid`
ReferencingEntityNavigationPropertyName	`ownerid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

Socialprofile_customer_accounts

One-To-Many Relationship: account Socialprofile_customer_accounts

Property	Value
ReferencedEntity	`account`
ReferencedAttribute	`accountid`
ReferencingAttribute	`customerid`
ReferencingEntityNavigationPropertyName	`customerid_account`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

Socialprofile_customer_contacts

One-To-Many Relationship: contact Socialprofile_customer_contacts

Property	Value
ReferencedEntity	`contact`
ReferencedAttribute	`contactid`
ReferencingAttribute	`customerid`
ReferencingEntityNavigationPropertyName	`customerid_contact`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `Cascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

socialProfile_owning_user

One-To-Many Relationship: systemuser socialProfile_owning_user

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`owninguser`
ReferencingEntityNavigationPropertyName	`owninguser`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

transactioncurrency_SocialProfile

One-To-Many Relationship: transactioncurrency transactioncurrency_SocialProfile

Property	Value
ReferencedEntity	`transactioncurrency`
ReferencedAttribute	`transactioncurrencyid`
ReferencingAttribute	`transactioncurrencyid`
ReferencingEntityNavigationPropertyName	`transactioncurrencyid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

SocialProfile_AsyncOperations
socialprofile_connections1
socialprofile_connections2
SocialProfile_DuplicateBaseRecord
SocialProfile_DuplicateMatchingRecord
socialprofile_principalobjectattributeaccess
SocialProfile_ProcessSessions
Socialprofile_SocialActivities
SocialProfile_SyncErrors

SocialProfile_AsyncOperations

Many-To-One Relationship: asyncoperation SocialProfile_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SocialProfile_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

socialprofile_connections1

Many-To-One Relationship: connection socialprofile_connections1

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record1id`
ReferencedEntityNavigationPropertyName	`socialprofile_connections1`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

socialprofile_connections2

Many-To-One Relationship: connection socialprofile_connections2

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record2id`
ReferencedEntityNavigationPropertyName	`socialprofile_connections2`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SocialProfile_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord SocialProfile_DuplicateBaseRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`baserecordid`
ReferencedEntityNavigationPropertyName	`SocialProfile_DuplicateBaseRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SocialProfile_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord SocialProfile_DuplicateMatchingRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`duplicaterecordid`
ReferencedEntityNavigationPropertyName	`SocialProfile_DuplicateMatchingRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

socialprofile_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess socialprofile_principalobjectattributeaccess

Property	Value
ReferencingEntity	`principalobjectattributeaccess`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`socialprofile_principalobjectattributeaccess`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SocialProfile_ProcessSessions

Many-To-One Relationship: processsession SocialProfile_ProcessSessions

Property	Value
ReferencingEntity	`processsession`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SocialProfile_ProcessSessions`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 110 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Socialprofile_SocialActivities

Many-To-One Relationship: socialactivity Socialprofile_SocialActivities

Property	Value
ReferencingEntity	`socialactivity`
ReferencingAttribute	`postfromprofileid`
ReferencedEntityNavigationPropertyName	`Socialprofile_SocialActivities`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SocialProfile_SyncErrors

Many-To-One Relationship: syncerror SocialProfile_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SocialProfile_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Partilhar via

Social Profile (SocialProfile) table/entity reference