cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EC_1
Level: Powered On

Create a flow that sends an email if a table in SQL wasn't updated during the day

I want to te create a flow that checks the last time that a table in SQL was updated
if the table wasn't updated between 6:00 am and 6:00 pm send an email 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create a flow that sends an email if a table in SQL wasn't updated during the day

 

Hi @EC_1 ,

 

There is no field in the SQL table to record the time when the record was changed, so we need to use other table/ list to record whether the SQL table has been changed within a specified period of time.

Please consider using the following method to configure Flow. We need to create a SharePoint List.

  • Create a new Flow and use When an item is modified (V2) as the trigger to determine whether the current time is at 6:00 am and 6:00 pm. If so, create an item in the list.
  • Create another Flow and run it once a day to see if there are items in the list created yesterday. If not, it means that the SQL table yesterday has not been changed within the specified time period.

Image reference:

35.PNG

Another Flow:

36.PNG37.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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

1 REPLY 1
Community Support Team
Community Support Team

Re: Create a flow that sends an email if a table in SQL wasn't updated during the day

 

Hi @EC_1 ,

 

There is no field in the SQL table to record the time when the record was changed, so we need to use other table/ list to record whether the SQL table has been changed within a specified period of time.

Please consider using the following method to configure Flow. We need to create a SharePoint List.

  • Create a new Flow and use When an item is modified (V2) as the trigger to determine whether the current time is at 6:00 am and 6:00 pm. If so, create an item in the list.
  • Create another Flow and run it once a day to see if there are items in the list created yesterday. If not, it means that the SQL table yesterday has not been changed within the specified time period.

Image reference:

35.PNG

Another Flow:

36.PNG37.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
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

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,847)