Create Button for Export Data and Save As

[TreadSlim]

I would like to create a button in plain sight rather than expect the user to see the "..." to export the data from my visuals. Is there a way to make a button mimic exactly what the "Export data" selection does?

[amitchandak]

@TreadSlim , I think using power automate you can do

https://www.youtube.com/watch?v=BnTipbooeP0

https://www.youtube.com/watch?v=sd3YCjN8Co4

[TreadSlim]

Thanks for the reply. Yeah, I saw that video but Power Automate doesn't appear to have a "Save As" feature built into it--rather, it's built-in flows require to connect to another program such as Outlook or SharePoint. There may be a way to do what I need in Power Automate, but if it isn't built-in, I have no idea how to do it.

[TreadSlim · Accepted solution]

I was able to do a workaround by creating a button > Action > Web URL. I copied the link to the Excel file (minus any link info after the filename so it doesn't just open the file) and it initiates the Save As dialog.

[awarriorpoet]

Would be helpful to show how you got the URL.  Thx.

[IAintNoRobot]

Yeah, how did you get the link to the Excel file?

[adeelirfa504]

How did you get the link to the Excel file?