Hi, can someone help or share how did you create a flow steps when an email arrives for new SysAid ticket with table using Power Automate to post in MS teams? Thanks!
Question
Ticket Alert using Power Automate
+4Hi there,
SysAid Copilot is here with our AI Magic!
Here is the response we thought might assist you:
SysAid Copilot is here with our AI Magic!
Here is the response we thought might assist you:
**AI magic at your service!**
To create a flow in Power Automate that posts a new SysAid ticket to Microsoft Teams when an email arrives, follow these steps:
**Step 1: Set Up Email Trigger**
1. Log in to Power Automate.
2. Click on 'Create' and select 'Automated flow'.
3. Choose 'When a new email arrives (V3)' as the trigger.
4. Configure the trigger to monitor the email account where SysAid tickets are received.
**Step 2: Parse Email Content**
1. Add a 'Get email' action to retrieve the email content.
2. Use the 'HTML to Text' action to convert the email body to plain text if necessary.
3. Add a 'Parse JSON' action to extract ticket details from the email body. You may need to define a JSON schema based on the email format.
**Step 3: Create a Table with Ticket Details**
1. Add a 'Compose' action to format the ticket details into a table. Use HTML or Markdown to create the table structure.
**Step 4: Post to Microsoft Teams**
1. Add a 'Post a message (V3)' action to send the formatted table to a Teams channel.
2. Configure the action to specify the Team and Channel where the message should be posted.
3. In the message content, include the table created in the previous step.
**Step 5: Test and Save the Flow**
1. Test the flow by sending a test email to the monitored account.
2. Verify that the flow triggers and posts the ticket details to the specified Teams channel.
3. Save the flow once you confirm it works as expected.
If you encounter any issues or need further assistance, please let me know!
To create a flow in Power Automate that posts a new SysAid ticket to Microsoft Teams when an email arrives, follow these steps:
**Step 1: Set Up Email Trigger**
1. Log in to Power Automate.
2. Click on 'Create' and select 'Automated flow'.
3. Choose 'When a new email arrives (V3)' as the trigger.
4. Configure the trigger to monitor the email account where SysAid tickets are received.
**Step 2: Parse Email Content**
1. Add a 'Get email' action to retrieve the email content.
2. Use the 'HTML to Text' action to convert the email body to plain text if necessary.
3. Add a 'Parse JSON' action to extract ticket details from the email body. You may need to define a JSON schema based on the email format.
**Step 3: Create a Table with Ticket Details**
1. Add a 'Compose' action to format the ticket details into a table. Use HTML or Markdown to create the table structure.
**Step 4: Post to Microsoft Teams**
1. Add a 'Post a message (V3)' action to send the formatted table to a Teams channel.
2. Configure the action to specify the Team and Channel where the message should be posted.
3. In the message content, include the table created in the previous step.
**Step 5: Test and Save the Flow**
1. Test the flow by sending a test email to the monitored account.
2. Verify that the flow triggers and posts the ticket details to the specified Teams channel.
3. Save the flow once you confirm it works as expected.
If you encounter any issues or need further assistance, please let me know!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
