I am trying to figure out a solution for the below requirement. Sometimes my coworkers will need to populate an Excel table (in coworker's business Onedrive) as shown in the picture. There are couple of locations and positions, and the additional information, like Employee Name and other data may need to come from an source Excel file in Sharepoint drive or my Business Onedrive. I can't give the source file to others so it would be best to come up a way my coworker can retrieve the additional information with a HTTP call to my Power Automate flow. I know there is a Webservice function in Excel but not sure how I can set up the flow on my side to receive the HTTP request with the parameters, look up the source Excel file on Sharepoint or my business Onedrive, and return the value.
Please help me come up with some ideas and thanks in advance.
