tboneotter
New Member
- Joined
- Jun 30, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
- Web
Hey Mr. Excel Boards,
So, the short question is that, is there any way to display/add the refresh date to an online pivot table?
Long question:
I / my boss has built a PowerAutomate (cloud) flow that iterates over a bunch of excel documents in sharepoint, then runs an office script in each one to find if a specific pivot table exists (I've even gotten it to pull a specific cell from a pivot table). Problem is, the next step is to pull the most recent refresh date of that pivot table. I know it's super easy in excel desktop with the .RefreshDate command in a macro, but these are in excel online, and I can't really have the flow run each one in excel desktop and run a macro (unless there's an easier way to do this that isn't downloading each excel doc...). But, it seems like all the pivotTable metadata isn't easy to find in Excel Online, and there isn't an Office Script command like .RefreshDate.
So, is there any way to display the most recent refresh date in a pivot table? If I can add a "Today" field to where the pivot table is refreshed from, can I pull that as a value into the pivottable on refresh, then get my script to grab that value? I'm relatively new to pivot tables especially with external refreshing, so anything would be appreciated.
Best,
Thomas
So, the short question is that, is there any way to display/add the refresh date to an online pivot table?
Long question:
I / my boss has built a PowerAutomate (cloud) flow that iterates over a bunch of excel documents in sharepoint, then runs an office script in each one to find if a specific pivot table exists (I've even gotten it to pull a specific cell from a pivot table). Problem is, the next step is to pull the most recent refresh date of that pivot table. I know it's super easy in excel desktop with the .RefreshDate command in a macro, but these are in excel online, and I can't really have the flow run each one in excel desktop and run a macro (unless there's an easier way to do this that isn't downloading each excel doc...). But, it seems like all the pivotTable metadata isn't easy to find in Excel Online, and there isn't an Office Script command like .RefreshDate.
So, is there any way to display the most recent refresh date in a pivot table? If I can add a "Today" field to where the pivot table is refreshed from, can I pull that as a value into the pivottable on refresh, then get my script to grab that value? I'm relatively new to pivot tables especially with external refreshing, so anything would be appreciated.
Best,
Thomas