cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
freki

Update All action (data) in Excel

Submitted by freki on โ€Ž07-23-2018 05:06 AM

Hi,

 

I'm trying to automate an email distribution process which involves updating an excel sheet with fresh data from a number of SQL queries, saving the updated sheet as pdf (after all queries are done and excel has recalculated cells) and emailing it to a list of receipients.

 

Together with the existing file conversion from xlsx to pdf and email distribution via Outlook, if the Update All action in Excel were to be added as a possible action in MS Flow it would grant users a powerful way of automating dynamic excel reports distribution.

Status: New
1 Comment (1 New)
Comments
Esmond
Esmond
Level: Power Up
โ€Ž02-14-2019 12:22 AM

I have the same issue - I have completed the Flow where the file is converted to a PDF and emailed to a list of people - that works. BUT I have not found a way to refresh the Excel data and pivot table which resides in the same file on a different worksheet. Seems to be an issue and wish list request since 2016.

 

Have you found a solution yet?