In order to retrieve images from Excel, you will need to use scripting, such as VBscript, PowerShell or similar. No other nice way to do it.
Here's a sample VBscript code to do it:
' Get the folder path where you want to save the images from the Power Automate variable
Path = "%ImagesPath%"
' Get the path to the Excel file from the Power Automate variable
ExcelFilePath = "%FilePath%"
' Initialize the counter
i = 1
' Create a new instance of Excel
Set Excel = CreateObject("Excel.Application")
' Open the workbook
Set Workbook = Excel.Workbooks.Open(excelFilePath)
' Set the worksheet that contains the images
Set Worksheet = Workbook.Sheets("Sheet1")
'Loop through each picture in the worksheet
For Each Picture In Worksheet.Pictures
' Set file name
FileName = "Pic " & i & ".png"
' Save the picture as a .png file
Picture.Select
Picture.CopyPicture
With Excel.Charts.Add
.Paste
.Export Path & FileName
.Delete
End With
' Increment the counter
i = i + 1
Next
'Close the workbook and the Excel app
Workbook.Close
Excel.Quit
This will save all images in a folder you define, each of them named "Pic 1.png", "Pic 2.png", etc.
You can then use Get files in folder to get those files and then loop through them, and then use Convert file to base64 to get the base64 string for each file.
You should then be able to do whatever you need with it - whether writing it to the same Excel sheet, or pushing it to this other app that you need it in.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
