반응형
[Power Automate Desktop] 변수 속성 (데이터 유형별)
1. 변수 속성 읽는 법
%변수명.속성%
2. 변수 속성
Texts
Length | The length of the stored text in characters. |
isEmpty | This property is true if the variable is empty or false if it contains some characters. |
ToUpper | The text of the variable written in upper case characters. |
ToLower | The text of the variable written in lower case characters. |
Trimmed | The text of the variable written without white characters in the begging and the end. |
Dates
Year | The year part of the datetime value. |
Month | The month part of the datetime value. |
Day | The day part of the datetime value. |
DayOfWeek | The name of the day (Sunday, Monday etch). |
DayOfYear | The day of the year part of the datetime value (1-365/6). |
Hour | The hour part of the datetime value. |
Minute | The minute part of the datetime value. |
Second | The seconds part of the datetime value. |
Lists
Count | The number of items stored into the list. |
Files
FullName | The full path to the file. |
RootPath | The root path of the file, for example C:\. |
Directory | The directory where the file is stored. |
Name | The name of the file, including the extension. |
NameWithoutExtension | The name of the file without its extension. |
Extension | The extension of the file. |
Size | The size of the file in bytes. |
CreationTime | The date when the file was created. |
LastAccessed | The date when the file was last accessed. |
LastModified | The date when the file was last modified. |
IsHidden | This property is true if the file is hidden or false if the file is visible. |
IsSystem | This property is true if the file is a system file or false if it isn't. |
IsReadOnly | This property is true if the file is read only or false if it isn't. |
IsArchive | This property is true if the file is an archive or false if it isn't. |
Exists | This property is true if the file exists or false if the file doesn't exist. |
isEmpty | This property is true if the file is empty or false if the file isn't empty. |
Folders
FullName | The full path to the folder. |
RootPath | The root path of the folder, for example, C:\. |
Parent | The parent directory of the folder. |
Name | The name of the folder. |
CreationTime | The date when the folder was created. |
LastModified | The date when the folder was last modified. |
IsHidden | This property is true if the folder is hidden or false if the folder is visible. |
Exists | This property is true if the folder exists or false if the folder doesn't exist. |
isEmpty | This property is true if the folder is empty or false if the folder isn't empty. |
FilesCount | The number of files in the folder. |
FoldersCount | The number of folders in the folder. |
Mail messages
MailFolder | The name folder the email message is retrieved from. |
Uid | The unique identifier of the message. |
From | The sender of the email message. |
To | A list of values containing the recipients of the message. |
Cc | A list of values containing additional recipients for the message (carbon copy). |
Date | The date and time in which the message was sent. |
Subject | The subject of the message. |
Body | The body of the message. The body can be in plain text or in HTML form. |
BodyText | If the previous property contains HTML, this property contains the body of the message in plain text form. |
Attachments | A list of files that represent the saved attachments of the email message (if any). |
Exchange connection
ServerAddress | The address of the Exchange server. |
Exchange mail messages
MailFolder | The name folder the email message is retrieved from. |
ItemId | The unique identifier of the message. |
From | The sender of the email message. |
To | A list of values containing the recipients of the message. |
Cc | A list of values containing additional recipients for the message (carbon copy). |
Date | The date and time in which the message was sent. |
Subject | The subject of the message. |
Body | The body of the message. The body can be in plain text or in HTML form. |
BodyText | If the previous property contains HTML, this property contains the body of the message in plain text form. |
Attachments | A list of files that represent the saved attachments of the email message (if any). |
Outlook mail messages
MailFolder | The name folder the email message is retrieved from. |
EntryId | The unique identifier of the message. |
From | The sender of the email message. |
To | A list of values containing the recipients of the message. |
Cc | A list of values containing additional recipients for the message (carbon copy). |
Bcc | A list of values containing additional recipients for the message (blind carbon copy). |
Date | The date and time in which the message was sent. |
Subject | The subject of the message. |
Body | The body of the message. The body can be in plain text or in HTML form. |
BodyText | If the previous property contains HTML, this property contains the body of the message in plain text form. |
Attachments | A list of files that represent the saved attachments of the email message (if any). |
FTP files
FullName | The full path to the file. |
Directory | The directory where the file is stored on the FTP Server. |
Name | The name of the file, including the extension. |
NameWithoutExtension | The name of the file without its extension.message. |
Extension | The extension of the file. |
Size | The size of the file in bytes. |
LastModified | The date when the file was last modified. |
FTP folders
FullName | The full path to the folder. |
Parent | The parent directory of the folder. |
Name | The name of the folder. |
LastModified | The date when the folder was last modified. |
FTP connection
Host | The host of the FTP connection. |
SecurityProtocol | The security protocol used in the connection. |
Datatables
RowsCount | The number of rows of the data table. |
Columns | A list that contains the names of the columns of the data table. |
IsEmpty | This property is true if the datatable is empty or false if it is contains elements. |
Datarows
ColumnsCount | The number of columns that the data row holds. |
ColumnsNames | A list that contains the headers of the datarow. |
Web browser instance
DisplayRectangleX | The position of the top-left corner of the window in the x axel. |
DisplayRectangleY | The position of the top-left corner of the window in the y axel. |
Handle | The handle of the browser instance. |
HtmlDialogs | Contains the dialogs of the current page, if they exist. |
IsAlive | This property is true if the browser window is alive or false if it isn't. |
Window instance
Handle | The handle of the window instance. |
Excel instance
Handle | The handle of the Excel instance. |
SQL connection
ConnectionString | The connection string used for the database connection. |
IsClosed | This property is true if the browser window is closed or false if it is open. |
CMD session
IsAlive | This property is true if the CMD session is alive or false if it isn't. |
ProcessId | The unique identifier of the process. |
Terminal session
IsTerminated | This property is true if the terminal session is terminated or false if it isn't. |
XML node
Children | The children of the XML node. |
InnerText | The inner text of the XML node. |
InnerXML | The inner XML of the XML node . |
Name | The name of the XML document. |
OuterXML | The outer XML of the XML node. |
Parent | The parent of the XML node. |
Value | The value of the XML node. |
Active Directory entry
LdapPath | The LDAP path of the Active Directory connection. |
Group info
Description | The description of the group. |
DisplayName | The display name of the group. |
Members | A list containing the members of the group. |
Name | The name of the group. |
User info
City | The city uf the user. |
Company | The company of the user. |
Country | The country of the user. |
Department | The department of the user. |
The email of the user. | |
Extension | The extension of the user. |
FirstName | The first name of the user. |
Initials | The initials of the user. |
LastName | The last name of the user. |
PostalCode | The postal code of the user. |
State | The state of the user. |
StreetAddress | The address of the user. |
TelephoneNumber | The phone number of the user. |
Title | The title of the user. |
EBS snapshot
DataEncryptionKeyId | The id of the data encryption key. |
Description | The description of the snapshot. |
Encrypted | This property is true if the snapshot is encrypted. |
KmsKeyId | The The identifier of the AWS Key Management Service customer master key to use for encryption. |
OwnerAlias | The alias of the owner. |
OwnerId | The id of the owner. |
Progress | The progress of the snapshot. |
SnapshotId | The id of the snapshot. |
StartTime | The start time of the snapshot. |
State | The state of the snapshot. |
StateMessage | The state message of the snapshot. |
Tags | The tags of the snapshot. |
VolumeId | The volume id. |
VolumeSize | The size of the volume. |
EBS volume
Attachments | The attachments of the volume. |
AvailabilityZone | The availability zone of the volume. |
CreateTime | This creation time of the volume. |
Encrypted | This property is true if the volume is encrypted. |
FastRestored | This property is true if the fast restore is enabled. |
Iops | The max IOPS of the volume. |
KmsKeyId | The The identifier of the AWS Key Management Service customer master key to use for encryption. |
MultiAttachEnabled | This property is true if the multi-attach is enabled. |
OutpostArn | The Amazon Resource Name (ARN) of the outpost. |
Size | The size of the volume. |
SnapshotId | The id of the snapshot. |
State | The state of the volume. |
Tags | The tags of the volume. |
VolumeId | The id of the volume. |
VolumeType | The type of the volume. |
Azure managed disk
AvailabilityZones | The availability zones of the disk. |
Configuration | The configuration of the disk. |
Encrypted | This property is true if the disk is encrypted. |
IopsSLimit | The max IOPS of the disk. |
IsAttachedToVirtualMachine | This property is true if the disk is attached to a virtual machine. |
OperationSystem | The operation system installed on the disk. |
SizeInGB | The size of the disk in GB. |
State | This state of the disk. |
ThroughputLimit | The throughput limit of the disk. |
TimeCreated | The creation time of the disk. |
Type | The type of the disk. |
VirtualMachine | The virtual machine that the disk is attached to. |
ResourceGroup | The resource group of the disk. |
Id | The id of the disk. |
Location | The location of the disk. |
Name | The name s of the disk. |
SubscriptionId | The subscription id of the disk. |
Tags | The tags of the disk. |
Azure resource group
ProvisioningState | The provisioning state of the resource group. |
Id | The id of the resource group. |
Location | This location of the resource group. |
Name | The name of the resource group. |
SubscriptionId | The subscription id of the resource group. |
Tags | The tags of the resource group. |
Azure snapshot
CreationSourceId | The creation source id of the snapshot. |
CreationSourceType | The creation source type of the snapshot. |
OperationSystem | This operation system on the the snapshot. |
SizeInGB | The size of the snapshot in GB. |
StorageAccountType | This storage account type of the snapshot. |
TimeCreated | The creation time of the snapshot. |
ResourceGroup | The resource group of the snapshot. |
id | This id of the snapshot. |
Location | The location of the snapshot. |
Name | The name of the snapshot. |
SubscriptionId | The subscription id of the snapshot. |
Tags | The tags of the snapshot. |
반응형
댓글