Power Automate (Microsoft Flow) Actions

Tickets

Array of tickets. All custom fields listed in $select parameter are returned in the customFields object.

Example of ticket in JSON format:

{
    "subject": "Site issues",
    "requester": { ... },
    "assignedTo": { ... },
    "status": "In progress",
    "category": "Question",
    "priority": "High",
    "dueDate": "2018-04-27",
    "created": "2018-04-27,
    "resolutionDate": "",
    "cc": [],
    "tags": [],
    "attachments": null,
    "id": 1,
    "customFields": {}
}

$select

An ODATA $select query option to specify which fields to return for a list item. You can use * to return all available fields.

SupportChannel,HelpDeskMailbox,Metadata/IsRead

$filter

An ODATA $filter query option to restrict the entries returned

Priority eq ‘High’

$top

An ODATA $top query option to select the first n items of the return set for return (default = 50, maximum = 100).

100

Ticket

Created ticket. All custom fields listed in $select parameter are returned in the customFields object.

Example of ticket in JSON format:

{
    "subject": "Site issues",
    "requester": { ... },
    "assignedTo": { ... },
    "status": "In progress",
    "category": "Question",
    "priority": "High",
    "dueDate": "2018-04-27",
    "created": "2018-04-27,
    "resolutionDate": "",
    "cc": [],
    "tags": [],
    "attachments": null,
    "id": 1,
    "customFields": {}
}

Ticket Subject

Subject

Printer issues

Ticket Requester Email

Requester email

j.davis@example.com

Ticket Status

Status name

In progress

Ticket Priority

Priority name

High

Ticket Cc Emails

Array if Cc emails

[“j.davis@example.com”, “m.smith@example.com”]

Ticket Attachments

Array of object containing File Names and File Contents.

1. Manual adding of attachments. Specify a file name and pass its content from another action. To add an attachment item, click an accordant button. Check the “Ticket Attachments” section of the action on the screenshot below.

2. Dynamical adding of attachments. If the number of attachments varies and depends on output of other actions, then use the approach described in this article.

Ticket Custom Fields

JSON object with custom field values to be set. There is a specific way to set a multichoice field (check the “Languages” property).

Ticket Id

Ticket ID to delete

1

Ticket

Requested ticket. All custom fields listed in $select parameter are returned in the customFields object.

Example of ticket in JSON format:

{
    "subject": "Site issues",
    "requester": { ... },
    "assignedTo": { ... },
    "status": "In progress",
    "category": "Question",
    "priority": "High",
    "dueDate": "2018-04-27",
    "created": "2018-04-27,
    "resolutionDate": "",
    "cc": [],
    "tags": [],
    "attachments": ["error.png"],
    "id": 1,
    "customFields": {}
}

Ticket Id

Ticket identifier

15

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

Metadata

Attachment

Requested attachment file

Ticket Id

Ticket identifier

15

Ticket

Updated ticket.

Example of ticket in JSON format:

{
    "subject": "Site issues",
    "requester": { ... },
    "assignedTo": { ... },
    "status": "In progress",
    "category": "Question",
    "priority": "High",
    "dueDate": "2018-04-27",
    "created": "2018-04-27,
    "resolutionDate": "",
    "cc": [],
    "tags": [],
    "attachments": null,
    "id": 1,
    "customFields": {}
}

Ticket Id

Ticket identifier

15

Ticket Body

Body

My printer is not working, please help ASAP.

Ticket Assignee Email or Sharepoint Group

Assignee email or the name of SharePoint group to which the ticket will be assigned to.

j.davis@example.com or IT support

Ticket Category

Category name

Problem

Ticket DueDate

DueDate

01.05.2018

Ticket Tags tagTitles

Array of ticket tags, new tags will be created in Tags list automatically.

[“Printers”, “MS Windows”]

Ticket Support Channel

Support channel name, if no value is provided, it will be set to API

Company site

Comments

Array of comments. All custom fields listed in $select parameter are returned in the customFields object.

Example of comment in JSON format:

{
    "body": "The issue is still not resolved!",
    "created": "2018-04-28T09:48:07Z",
    "fromEmail": "j.jones@example.com",
    "fromName": "James Jones",
    "messageId": null,
    "id": 25,
    "customFields": {}
}

Ticket Id

Ticket identifier

1

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

From

$orderBy

An ODATA $orderBy query option for specifying the order of entries.

ID desc

Comment

Created comment

Example of comment in JSON format:

{
    "body": "The issue is still not resolved!",
    "created": "2018-04-28T09:48:07Z",
    "fromEmail": "j.jones@example.com",
    "fromName": "James Jones",
    "messageId": null,
    "id": 25,
    "customFields": {}
}

Ticket Id

Ticket identifier

1

Comment Author Email

Email of the author of the comment

j.jones@example.com

Comment MessageId

Message-ID of email message, if comment is being created from email

<SN2PR0501MB105.namprd05.prod.outlook.com>

Comment

Comment

Example of comment in JSON format:

{
    "body": "The issue is still not resolved!",
    "created": "2018-04-28T09:48:07Z",
    "fromEmail": "j.jones@example.com",
    "fromName": "James Jones",
    "messageId": null,
    "id": 25,
    "customFields": {}
}

Ticket Id

Ticket identifier

1

$select

An ODATA $select query option to specify which fields to return for a list item. You can use * to return all available fields.

CommentType,From/Role

Contacts

Array of contacts. All custom fields listed in $select parameter are returned in the customFields object.

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

$select

An ODATA $select query option to specify which fields to return for a list item. You can use * to return all available fields.

PhoneNumber,IsValidated,Organization/Title

$filter

An ODATA $filter query option to restrict the entries returned

Role eq ‘Agent’

$top

An ODATA $top query option to select the first n items of the return set for return (default = 50, maximum = 100).

100

Contact

All custom fields listed in $select parameter are returned in the customFields object.

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

Contact Name

Full name of the contact

Mary Cane

Contact SPUserId

You can provide a SharePoint user ID instead of contact Email, if you want to create Agent or Member. The field is not mandatory

15

Contact Alterate Email

Alterate email address for the contact

m.cane@outlook.com

Update if exists

If contact with specified email already exists and “Update if exists” parameter is set to “Yes”, contact information will be updated

Yes

Requested contact

All custom fields listed in $select parameter are returned in the customFields object.

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

Contact Email

Contact email

m.cane@example.com

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

Organization

Contact

Updated contact

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

Contact Email

Email of the contact

m.cane@example.com

Contact SPUserId

You can provide SPUser ID instead of contact email, if you want to create Agent or Member

15

Contact Alterate Email

Alterate email address for the contact

m.cane@outlook.com

Contact Id

Contact ID to delete

1

Requested contact

All custom fields listed in $select parameter are returned in the customFields object.

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

Contact Id

Contact identifier

20

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

Organization

Contact

Updated contact

Example of contact in JSON format:

{
    "title": "Mary Smith",
    "email": "m.smith@example.com",
    "spUserId": 0,
    "role": "End-User",
    "emailAlternate": "m.smith@google.com",
    "id": 20,
    "customFields": {}
}

Contact Id

Contact identifier

20

Contact Email

Email of the contact

m.cane@example.com

Contact Role

Role of the contact in HelpDesk

En-User, Member or Agent

Contact Custom Fields

JSON object with custom field values to be set.

Organizations

Array of organizations. All custom fields listed in $select parameter are returned in the customFields object.

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

$select

An ODATA $select query option to specify which fields to return for a list item. You can use * to return all available fields.

Region,IsPartner,ManagerContact/Email

$filter

An ODATA $filter query option to restrict the entries returned

Region eq ‘Asia’

$top

An ODATA $top query option to select the first n items of the return set for return (default = 50, maximum = 100).

100

Organization

Created organization

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

Organization Title

Title of the organization

Plumsail

Organization Id

Organization identifier

15

Organization

Found organization

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

Organization Id

Organization identifier

15

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

ManagerContact

Organization

Updated organization

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

Organization Id

Organization identifier

15

Organization Custom Fields

JSON object with custom field values to be set.

Organization title

Organization Title

New tree inc.

Organization

Found organization

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

Organization title

Organization Title

New tree inc.

$expand

An ODATA $expand query option to specify that the request returns the values of lookups.

ManagerContact

Organization

Updated organization

Example of Organization in JSON format:

{
    "title": "Plumsail",
    "id": 1,
    "customFields": {}
}

Organization Title

Title of the organization

New tree inc.