Power Platform Community Forum Thread Details

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.

Get Row number of the image. Name the object with row number like "Picture 1" for row 1, "Picture 2" for row 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.
Use this base64 string in other data sources.

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

Categories:

Building flows