Hi,
I have about 15 Excel reports located on SharePoint. Excel files get data from SQL Server.
I need to refresh Excel data every day by clicking „RefreshAll” and some of them 6 times a day. Operations are easy:
- Open Excel file on SharePoint
- Click "RefreshAll" data = (Ctrl + Alt + F5)
- Save Excel (Ctrl + S)
- Close Excel (Alt + F4)
Everything is working "manually”. 😮
I tried to automate it with MS Power Automate (PA) but I still have different problems.
- I’d like to do it with PA Web version. I don’t want to use a function built-in SharePoint.
- Sending a keyboard shortcut I found only in PA Desktop. Is it possible to send a keyboard shortcut with web PA version?
- Now, from Web PA I trigger a flow on Desktop PA, but it doesn’t work when my desktop is locked. I'd like to run a flow at night, so I want to lock my computer. How to solve such a problem?
Can you give me a link to an example (youtube or some screens on www) of a solution to that problem?
