Is it possible to pass the value obtained from REST to Excel (vba?) to open the workbook and filter the data?
Example: [StaffDirectory] list has the following columns and type
- StaffEmail / text
- Division / choice
Then, using REST to get the current user’s information — I want it to open a link to a worksheet that will use the same information to filter the data.
So if EmployeeA is in IT Division, the worksheet should only display IT Division records. Currently, the current user has to select a Division to filter the data but this allows staff to also view other Division’s data.
We are using Office 365 Government and currently can’t use Excel Web Access to refresh the data connection (ticket has been submitted) so I’m trying to find another solution.
