Add image in to excel table from base64

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Scenario

SPO list "Covid19_Compliance" has 3 column names 'PayLoad01', 'PayLoad02', 'PayLoad03'.

The data in these columns contains stringified JSON of user inputs which includes Texts, Camera captured images(base64).

SPO list is updated from PowerApps.

The Problem:

I am able to add all data from those columns into excel tables using Parse JSON & Excel Business connector.

But I am unaware how to add base64 encoded images into cell of excel table.

Also suggest me if I need to make changes at PowerApps level, like some alternatives instead of converting images to base64.

I need help 🙏

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (2)

fchopo 8,003 Moderator on at

Like (0)

Report

Hello @Anonymous
Could you try to convert your base64 image to binary and send it to excel by using dataUriToBinary() function?
Have a look at this thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-to-Flow-DataURIToBinary/td-p/156177
Hope it helps!
Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @fchopo ,
I have tried with the reference article you mentioned but it is giving following error-Excel Connector

InvalidTemplate. Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '1' and column '2784': 'The template language function 'dataUriToBinary' expects one parameter: the data URI that is to be converted to binary. The function was invoked with '0' parameters. Please see https://aka.ms/logicexpressions#dataUriToBinary for usage details.'.

The function is

dataUriToBinary(items('Apply_to_each')['p5'])

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

With the help of JSON parse connector, successfully converted image data URI to binary and updated in cell of table.
But in cell it shows something like ?PNG
So should I conclude that images can't be inserted to excel via flows.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata Hi, Can you help in this regard?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Anonymous shure.

So if you want something like this

I'm afraid my friend is not possible with PA, because and image is not part of a excel row, and image is like a frame inside excel, and until today this is not suppported by PA.

Another scenario is this

inserting data in base64 into excel to use it in Power Apps and show images by reading the data in excel.

Please let me know what scenario you are needing.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata
First of all I would like to congratulate you for being elevated as Super User 🎉🎉🎉

When user fills and submits information from PowerApps, a new item will be created in SPO list.
Then a flow will be triggered which will first parse JSON from PayLoad1, PayLoad2, PayLoad3 of SPO list item.
Then excel's Add Rows connector will fill up three tables from above data in a existing excel templete.
Excel sheet has 3 Tables(Table1,Table2,Table3).

All 3 tables' column names are same- SrNo, Area, Point, Status, Remark, Image(Optional). (Total 6 columns & 3 tables)
Then an email will be sent attaching that excel file to preset user email addresses.
After that all rows from all 3 tables will be deleted using another excel connector.(To make it ready for future flow trigger as a template).
Everything is running fine except image inserting issue in excel excel sheet table.

The need is to insert image in excel's Image(Optional) column. This is required.

(Off the topic question: How can I create my signature so that it added automatically when creating/replying to a post in this community forum? just like like outlook has that feature)

Best Regards,
Ankit Shah
Surat-India
Twitter: https://twitter.com/AnkitShah55

Was this reply helpful? Yes No
Verified answer

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Anonymous thanks my friend, it's a pleasure to help here.

@Anonymous wrote:
The need is to insert image in excel's Image(Optional) column. This is required.

It's a shame but unfortunally we can't do this with PA this is not supported yet.

And to answe your second question see it's in profile setting

I don't know if this is available for all users but is there jejeje

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata
Thanks friend for clarifying that, now I have no doubts and I can move forward.
What I am thinking to create a zip file containing that excel file and image files.
Every image file name will be copied to ImageName column in excel table.

Is this good practice? Or if you have idea?
(PS: I am convincing my senior to generate reports in PDF instead of excel, I can do it by using HTML)

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Anonymous excellent way my friend. You can create .rar file and then in excel add the url to that file.

Pd: If you can convince your superior to use pdf is better, because as you said you can use HTML, I don't know if you saw this video but I give you anyway https://www.youtube.com/watch?v=2rfAQe1kK8M, is a Shane Video

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ChristianAbata Yes I have watched that video, in fact I follow all videos and updates from Shane, (He is like a guru)
Well, Thanks for all help friend 👋

Was this reply helpful? Yes No