45
Hello Members,
I was trying to build a flow that can run every 15 minutes where, I want to refresh the Excel application (Desktop) Copy the data from desktop Excel, and paste it on another Excel that is available on SharePoint.
Flow would be like this > Schedule 15 Mins > Open Desktop Excel Refresh it, Copy data (Such as Name, Status, and ID) > Paste this data on the Excel available on SharePoint (under one folder)
@FLMike, Could you please help me with this flow on PAD, I see comments from str8_6, however I have one while which is full of macro hence unable to move on the sharepoint.
Hello Mike, thanks for reverting! Can you help me with desktop flow? I have access to Could and Desktop and will attache both the flow
Perhaps you can explain why the local excel file can't be a separate Sharepoint file also? It would simplify things if both excel files were on Sharepoint. You wouldn't even need Power Automate at that point because you could import the table in one excel into a different. Whenever File A is updated, the data auto refreshes in File B. You could also control when it refreshes within Excel itself (i.e. when file is opened, every X minutes, etc).
This is more of a Power Automate Desktop solution, to do what you want.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
