Convert JSON to Image

(0) Share

Report

Posted on by GrantC101

Hello Hoping to get some help

I have managed to get a Pen input to be saved as JSON in a SharePoint list.

I am now struggling to convert this into Image for use on a email and document.

I have had to use an existing SharePoint list and Power App from. I am unable to ask Power Apps and can only go off the information saved into the SharePoint item.

I am hoping I don't have to build something from scratch.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @GrantC101 ,

Could you tell me:
Have you stored many records with pictures in base64 format in the list?
Do you want to convert these base64 pictures into file format pictures?
After the conversion is completed, do you want to save the pictures to the sharepoint library or send the picture as an attachment by email?

If my assumptions are correct, the key is to build a flow.
I've made a test for your reference:
1\ This is my list ‘LIST69’

2\ Build an instant flow. When flow runs, it will convert all base64 formatted pictures in the list into files.

File Content: dataUriToBinary(items('Apply_to_each')?['Signature'])

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
GrantC101 31 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-xiaochen-msft

I have not stored many records with pictures in base64 format in the list
I would like to be able to put the signatures into a email and that be it.

The SharePoint list just stores the JSON, and I would keep a record of the Emails
I was looking at creating a flow when a SharePoint Item is created and then attach the signature with the existing attachment array.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @GrantC101 ,

Could you tell me:
Do you want to send an email when an item is created? Does the email contain many attachments? Does the attachments come from the attachment column of the item?
In addition to the attachments in the Item, do you want to convert the base64 signature image to an image file and send it to the user as an attachment?
In other words, if an item has 5 attachments, do you want to send an email containing 6 attachments (5 attachments + 1 signature file) ?

If my assumptions are correct, please try the steps below:
1\ Build my flow

Value: { "Name": @{items('Apply_to_each')?['DisplayName']}, "ContentBytes": @{body('Get_attachment_content')?['body']} }

Value: { "Name": "aa.png", "ContentBytes": @{dataUriToBinary(outputs('Get_item')?['body/Signature'])} }

2\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
GrantC101 31 on at

Like (0)

Report
Copy link

Link copied!

Hello @v-xiaochen-msft

You have assumed correct this is exactly what I want wont to achieve.

I have created the same flow as you have shown but now getting an error;

Unable to process template language expressions in action 'Append_to_array_variable_2' inputs at line '1' and column '3074': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI.

here is the flow;

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @GrantC101 ,

Please try to delete the action in the flow or recreate a new flow.
I ran into the same problem initially and solved it after rebuilding a flow.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
GrantC101 31 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-xiaochen-msft

For some reason it worked when I rebuilt it

Was this reply helpful? Yes No