You’re offline. This is a read only version of the page.
Announcements
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
Share
Report
All responses (
Answers (
503
