Business case: Create the alert message to Slack with MS Flow/Automate

-

 Business case:

Automatically post the alert message when it hits the criteria by using the store procedure in MS SQL Azure

Solution:

Assumption that we already had the data as following by writing it in the store procedure.









Comments

Post a Comment

Popular posts from this blog

Featured Projects: Automation and AI Systems I Built and Run

-
This is a living index of the systems I'm most proud of — each one is in daily production use, and each links to a deeper technical write-up. If you're a recruiter or hiring manager, this page is the fastest way to see what I actually build. 1. AI Email-Triage Pipeline (LLM classification in production) A pipeline that classifies hundreds of ticketing emails per day (presales, releases, cancellations) using multimodal LLMs, then distributes summarized reports automatically to the relevant business departments. I fine-tuned GPT-4o-mini on a labelled dataset I built from PDF archives, put OpenAI and Gemini behind a single interchangeable JSON contract for cost/performance trade-offs, and wrote a defensive C# parsing layer — balanced-brace JSON extraction, tolerant custom JsonConverters, code-enforced business invariants — so a single malformed model response never breaks the batch. Stack: C#/.NET, OpenAI API (fine-tuning), Gemini, IMAP, SQL Server Read more: Classifying E...
Read more

AWS API gateway, S3

-
Image
  Tutorial: Create a REST API as an Amazon S3 proxy in API Gateway - Amazon API Gateway Using REST API to upload files to the S3 bucket - BlueGrid : BlueGrid AIM role Edit Trust Relationship {   "Version": "2012-10-17",   "Statement": [     {       "Effect": "Allow",       "Principal": {         "Service": "s3.amazonaws.com"       },       "Action": "sts:AssumeRole"     },     {       "Effect": "Allow",       "Principal": {         "Service": "apigateway.amazonaws.com"       },       "Action": "sts:AssumeRole"     }   ] } Next, go to API Gateway --> create a REST API. Create the folder & item resource create GET -->  with "tanldttestingapigateway" is a S3 bucket name. /{folder}/{item} - GET - Method Execution --> to add URL path parameters Create the fo...
Read more

Business case: Monitor mailbox and auto-save the attachment to a SharePoint

-
Image
Business Case: - Monitors a shared mailbox for messages that contain the words "expense report" - Saves the attachment to a SharePoint Library called ExpenseReports - Marks the email as Read - Marks the email as Complete  Solution: Enter a value for Flow name, and then search the triggers for When a new email arrives in a shared mailbox (V2): Select SharePoint site Mark as read Flag email Result:
Read more