cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok
Level 10

Tips: Everyday, Post a data of SQL Server to Microsoft Teams

I want to share how to post a data of SQL Server to Microsoft Teams.

 

Summary:

Everyday, Get a data from SQL Server, and Post the data to Microsoft Teams.

 

Use Scenario:

Check a data of SQL Server at Microsoft Teams

 

Flow overview:

Trigger: Schedule - Recurrence

Action: SQL Server - Execute a SQL query

Action: Apply to each

- Action:Microsoft Teams - Post message

2018-08-16 (2).png

 

Trigger: Schedule - Recurrence

- Interval is 1

- Frequency is Day

2018-08-16 (3).png

 

Action: SQL Server - Execute a SQL query

- query is Select statement

- like: Select COUNT(*) as ResultCount from Table1

 

Action: Apply to each

- 'Select an output from previous steps' is 'ResultSet Table1' on Dynamic content - 'Execute a SQL query'

 

Action: Microsoft Teams - Post message

- Team ID is <your team>

- Channel ID is <your channel>

Click <see more> in 'Dynamic content' - 'Execute a SQL query', and after click, appear 'ResultCount' 

- Message is <ResultCount>

2018-08-16 (4).png

 

that all.

I'm using this flow to check a customer's Azure SQL Database, everyday.

 

Regards,

Yoshihiro Kawabata

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Tips: Everyday, Post a data of SQL Server to Microsoft Teams

Hi @yoshihirok,

 

Thanks for sharing. Your tips will be very helpful to customers who have the same request.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Tips: Everyday, Post a data of SQL Server to Microsoft Teams

Hi @yoshihirok,

 

Thanks for sharing. Your tips will be very helpful to customers who have the same request.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

yoshihirok
Level 10

Re: Tips: Everyday, Post a data of SQL Server to Microsoft Teams

Hi @v-yamao-msft

 

Yes, this Tips start with a customer's scenario

 

Regards,
Yoshihiro Kawabata

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,035)