Is it possible to send a Slack message when a drop down list in an online Excel file changes?

Hello everyone,

I was hoping to setup some kind of automation for our lab's ordering/purchasing process. We used to use Quartzy, but we are now moving on to inputting our orders using a shared online Excel (OneDrive) document. One nice feature Quartzy had was automatically notifying the person who ordered an item that their request was "ordered, received, cancelled, etc." via email. I would like to replicate this (if possible) in Excel/Slack, but email would also be okay. Example: "Your request for 50mL tubes has been marked as ordered." would be sent via DM to the person who ordered (triggered by our purchasing team selecting "ordered" from a drop down list).

However, when I navigate to the Excel document -> data tab -> Flow -> New, my only option seems to be "For a selected row." Is this function just extremely limited? Or am I just misunderstanding the point of the Power Automation? Could a script do this if PA can't? I am completely new to the feature, so any input or recommendations no how to achieve this would be greatly appreciated.

Thank you for your time!

amwitte1

Quick Links

Leaderboard > Power Automate