January 3, 2021
I have a query within spreadsheet B, that is held within a private channel in a MS Team. The query gets data from spreadsheet A that is held in another channel (thanks Amanda for your Get Data From SharePoint video!). Spreadsheet A has lots of sensitive data that I can only have access to, spreadsheet B is accessible to 6 members in my team and strips out the sensitive data through PQ and thus only presents non sensitive data.
Therefore, I'm the only one who can refresh the query in spreadsheet B, as my team members don't have access to spreadsheet A. I'm looking for spreadsheet B to be updated on a daily basis without me having to go in and manually having to refresh myself.
I was thinking of using 'Automate' within Excel Online and then running the script through PowerAutomate, however this does not record refreshing of a PQ. It appears you cannot use PowerAutomate to run a Macro either.
Are there any other options to automate this task?
July 16, 2010
October 27, 2021