So in my SharePoint. I have a folder for Travel Requests. Due to the amount of information, and my supervisor's preference I can't just turn all the items on the Excel file into a list. (That would make my life too easy) Here is a copy of the file:
So now, I am trying to set up the library to automatically read the Approver name so I can send them an email when the file is created, or to use the creator's department to find the correct person to receive the email.
Can this be done? And if it can, how do I do this?
I already treat this folder like a list for flow purposes, I just can't pull the manger's info from anywhere, and have no way to have the user give this info to SharePoint on item creation.