Hello, I am very new to PA so please bear with me. I am attempting to have an excel spreadsheet that is stored on SharePoint to automatically send an Outlook email notification when a specific column has a date added. We are attempting to create a production request form that would flow from Forms to Excel, and then the excel document can be modified by the production planner when a date is set. Once that date is added to the column, an email notification would be sent to the production team notifying them to add it to their calendar.
So far I have two flows, both are not working as intended (one is not working at all actually).
Flow 1 - this was my first go at making a flow to pull the data from a row in the excel file. It seems my issue here lies in the "Get a row" action as I cannot select any dynamic content from within the excel document, only from Sharepoint.
This is my second flow, this currently works but it sends separate emails for every row on the excel sheet every time anything is updated on the spreadsheet.
Again, I am very new to this so please let me know if I can provide additional info. Any help is GREATLY appreciated.
Thanks all!
