First, I'm very new to using power automate. I've been reading as much as I can and but I'm pretty stumped with this one. I can't seem to get power automate to trigger the excel document to refresh, to get up to date information, to then repost into teams to notify my team members of the data. I've tried adding a script and getting it to run said script, but no luck. I've also tried setting the document to refresh when opened and I've allowed background refresh, again to no avail. I am using power automate via the web, no desktop access from my work. Also, when this happens, I'd like for the message to be a complete pivot table. Coming up empty there as well. Any help would be greatly appreciated. Thanks in advance.
