Building a flow to convert multiline text column data to jpg and add as attachment and send to a Sharepoint folder

[Anonymous]

Hi,

I have several powerapps which create images in a multiline text column in a Sharepoint list, i need to create a flow that will convert those images to jpg in a Sharepoint list , add them as an attachment to that list item and add them to a Sharepoint folder.

Ive been working on this solutions for a better part of 6 months and i just cannot get it too work.

Could someone help me with this?  

[ChristianAbata]

hi @Anonymous cloud you share an screenshot?

[Anonymous]

---

@ChristianAbata wrote:

hi @Anonymous cloud you share an screenshot?

---

Its more which test flow do you want.. 😊 This problem has been plauging me for 6months+ 

[ChristianAbata]

@Anonymous  please could you share now an screanshot from your sharepoint list, I need to see the values in there.

[Anonymous]

---

@ChristianAbata wrote:

@Anonymous  please could you share now an screanshot from your sharepoint list, I need to see the values in there.

---

This is the list it is going into. Im trying to get them to be all stored in one multiline text column, (currently called ImageData) however some apps will use many columns

also not the top Imagedata file is Base64 and the second one is using this 

Set(varDemoFromAttachmentControl, JSON(TESTgalleryimage.Image, JSONFormat.IncludeBinaryData)); 
Set(varBase64Only, Mid(varDemoFromAttachmentControl, Find(",", varDemoFromAttachmentControl)+1, Len(varDemoFromAttachmentControl) - Find (",", varDemoFromAttachmentControl) -1 ))

to remove the unnessary stuff and display it in a gallery, its a work in progress to make this flow work..

[ChristianAbata]

Hi @Anonymous  I hope this solutions could help you.

For the outputs in sharepoint list that starts with data: you need to extract only the data before coma, this is going to be your file content.

Then to create a file, the one drive conector needs a json file this a especial squema so, you need to pass the type content and the file content. Please see my example.

the estrackpng function is

first(split(last(split(first(split(outputs('Base64Data'),',')),'/')),';'))

Please if this can helps you mask a solution to help others.

[Anonymous]

---

@ChristianAbata wrote:

Hi @Anonymous  I hope this solutions could help you.

For the outputs in sharepoint list that starts with data: you need to extract only the data before coma, this is going to be your file content.

Then to create a file, the one drive conector needs a json file this a especial squema so, you need to pass the type content and the file content. Please see my example.

the estrackpng function is

first(split(last(split(first(split(outputs('Base64Data'),',')),'/')),';'))

Please if this can helps you mask a solution to help others.

---

Firstly thankyou for your reply, i genuinely appreciate it.

But im confused, could you take a screenshot of the whole flow? and break it down a bit for me? or export the flow?

[ChristianAbata]

sure @Anonymous  try

[v-bacao-msft]

Hi @Anonymous ,

Have you had an opportunity to apply any of @ChristianAbata 's recommendations to adapt your Flow?

Please take a try.

Best Regards,