Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Get Positions of Images in an Excel table in terms or Row ID and Column ID using Office Scripts and Power Automate

(0) ShareShare
ReportReport
Posted on by 1,085

I have an excel sheet downloaded from a 3rd party API which has got a image column with images in each row. The image object is named as "Picture 1" on every image under the image column. Now I would like to generate the base64 string of this image so that I can use this image in other data sources like SharePoint, SQL Server etc. I figured out how to convert it to base 64. The problem I have is I am unable to get the position of this image in each row so I can define the base64 string of this image in the same row on a new column called "base64 text". I understood getRange function is not supported for images, charts or shapes. But how do I get the position of the image now? I tried searching all over but couldn't find anything. Here are the steps I would like to do using office script.

  1. Get Row number of the image. Name the object with row number like "Picture 1" for row 1, "Picture 2" for row 2.
  2. Once I have the row number, I would like to get the shape or image at this position and get base64 text of this image under "base64 text" column.
  3. Use this base64 string in other data sources.

Please help me with the directions. Thanks a lot in advance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard