I just got in to the Power Automate community and wanted to create a flow which will send a message to my team when the Excel sheet for ticket assignments is updated. I wanted to go even further and add specific values from cells to the message distributed in Teams.
For example:
Date and Time
Ticket no
Assigned to
04/02/2022
123321331
John Johnson
I wanted to create a flow which would, after I manually update these 3 columns, send a message to chat channel on Teams which will say something in lines of: New ticket [DateAndTime] for [AssignedTo] - ticket number is [TicketNo].