Hi @Korokd !
I can give you a flow using PAD but to do automatic flow runs definitely requires a premium license.
But I did see some info somewhere but haven't tried it out. Here are some links:
Run Flow From Command Prompt or Windows Task Scheduler | Power Automate Gallery
(given by @VJR )
YouTube links:
How to schedule in Power Automate Desktop WITHOUT Power Automate Cloud or Premium license)
One STEP hack to schedule in Power Automate Desktop WITHOUT Power Automate Cloud or Premium license)
The full flow:
I have used Python and PowerShell to accomplish this.
Make sure to have this installed into your system using cmd (Administrator):
pip install pyautogui openpyxl
Python script (save it as script.py in some folder):
import pyautogui
import openpyxl
from openpyxl.drawing.image import Image
from openpyxl.utils import get_column_letter
import time
from datetime import datetime
import os
# Function to take a screenshot
def take_screenshot(filename):
screenshot = pyautogui.screenshot()
screenshot.save(filename)
# Function to resize and insert image into Excel
def insert_resized_image_into_excel(image_path, excel_path, cell, width=None, height=None):
if not os.path.exists(excel_path):
# Create a new workbook if the file does not exist
wb = openpyxl.Workbook()
wb.save(excel_path)
else:
# Load existing workbook
wb = openpyxl.load_workbook(excel_path)
ws = wb.active
img = Image(image_path)
# Resize image if width or height is provided
if width and height:
img.width = width
img.height = height
ws.add_image(img, cell)
# Adjust column width to fit the resized image
column_letter = cell[0]
ws.column_dimensions[column_letter].width = img.width / 7 # Adjust as needed
wb.save(excel_path)
# Get the current date and format it
current_date = datetime.now().strftime('%A_%b_%d_%Y')
# Create the filenames
image_filename = f"C:/Users/Nathan/Desktop/TestingSaveScreenshotToExcel/screenshot_{current_date}.png"
excel_filename = f"ExcelFile_{current_date}.xlsx"
excel_path = f"C:/Users/Nathan/Desktop/TestingSaveScreenshotToExcel/{excel_filename}"
# Take screenshot
take_screenshot(image_filename)
# Insert resized image into Excel at specified cell and adjust column width
insert_resized_image_into_excel(image_filename, excel_path, 'A1', width=300, height=200) # Adjust width and height as needed
insert_resized_image_into_excel(image_filename, excel_path, 'D1', width=300, height=200) # Adjust width and height as needed
insert_resized_image_into_excel(image_filename, excel_path, 'H1', width=300, height=200) # Adjust width and height as needed
# Optional: Add delay to ensure the tasks are performed sequentially
time.sleep(5)
PowerShell script (have to put this in PAD using the Pre-built action):
# Run the Python script
Start-Process -FilePath '%pythonPath%' -ArgumentList '%scriptPath%' -NoNewWindow -Wait
Output:-
Before:
After:
Image:
Excel file:
And to run this every Wednesday, you would need premium using the Windows Task Scheduler. More info here in the link on how to set it up:
https://www.youtube.com/watch?v=pFZSajbQsxc by the infamous, Anders Jensen.
Code (just copy paste into your flow):
SET pythonPath TO $'''C:\\Python312\\python.exe'''
SET scriptPath TO $'''C:\\Users\\Nathan\\Desktop\\TestingSaveScreenshotToExcel\\script.py'''
WebAutomation.LaunchChrome.LaunchChrome Url: $'''https://www.activision.com/?utm_source=404&utm_medium=redirect&utm_campaign=122222''' WindowState: WebAutomation.BrowserWindowState.Maximized ClearCache: False ClearCookies: False WaitForPageToLoadTimeout: 60 Timeout: 60 PiPUserDataFolderMode: WebAutomation.PiPUserDataFolderModeEnum.AutomaticProfile BrowserInstance=> Browser
@@copilotGeneratedAction: 'False'
Scripting.RunPowershellScript.RunPowershellScript Script: $'''# Run the Python script
Start-Process -FilePath \'%pythonPath%\' -ArgumentList \'%scriptPath%\' -NoNewWindow -Wait''' ScriptOutput=> PowershellOutput ScriptError=> ScriptError
WebAutomation.CloseWebBrowser BrowserInstance: Browser
I hope this helps.
