Answered

Photo Powerapps - Base64

(0) Share

Report

Posted on by alessandramaced

308

HI I have a list in sharepoint to show and save photos to use in powerapps. The column that save image in base64. I have a lot of other photos that i want to add to sharepoint list. I converted one photo online and i did great. But I have a lot of photos. I created a file in excel and put a function in powerquery to convert photos from onedrive folder. Didn't work.

The function is: = (BinaryContent as binary) as text=> let Base64 = "data&colon;image/jpeg;base64, " & Binary.ToText(BinaryContent, BinaryEncoding.Base64) in Base64

excel file:

Don't show any error but don't show image in app. The formula in app is:

Filter(Fotoapp;IDEnd=Gallery3_1.Selected.Idend)

to save photos the bottom is:

Collect(Fotos_APP;{Title:"001";IDEnd:Gallery3_1.Selected.Idend;FotoTirada:Camera2.Photo})

I need to create another screen to upload photos. Anyone knows the easiest way to do it?

I tried with flow model but shows error in email part.

Thanks in advance.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @alessandramaced ,

I have done a a blog on managing images in Power Apps and although SharePoint focussed should work in Excel (although I have never tested it). Have a look at the syntax for saving in a Multiline text field (just get rid of the leading and trailing quotes and save the rest of the text) and a little further down the syntax for viewing (simply refer to the control content name).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
alessandramaced 308 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thanks a lot for reply. Gread blog! Congrats!

I live in brazil, portuguese language, here powerapps uses ";" instead ",".

The formula is shwoing error in final:

With(
{
vJSON:
With(
{
vJSONI:
JSON(
First(Fotos_APP).Url;
JSONFormat.IncludeBinaryData
)
};
Mid(
vJSONI;
Find(
",";
vJSONI
) + 1;
Len(vJSONI) -
Find(
",";
vJSONI
) - 1
)
)
};
'Foto-Powerapps'.Run(TextInput2.Text;
vJSON;
Gallery3_1.Selected.Idend
)
)

It's saying that expected 2 arguments and I'm using 3.
I don't know what to chance

Is that possible to put in formula to add ".jpg" to name?
Thanks in advance
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @alessandramaced ,

The error in the Flow run will depend on what you are sending it. I assumed that you would simply be patching the value to Excel ( so you do not need a Flow) and was guiding you on the syntax for the Base64 text, however what are the three parameters you are sending the Flow. The second is obviously the JSON text, but which of the first (a text input) and the third (a gallery item value) is the file name? Also to add the extension, simply concatenate it on the end

TextInput2.Text & ".jpg"

as an example on the first one.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
alessandramaced 308 on at

Like
a
(0)

Report
Copy link

Link copied!

I’m not using excel anymore.
I did it equal to your example in blog.
Only sharepont list and I will use camera and upload. And a sharepoint colletion as you did it
Using same solution for both as you say in blog.
I did equal to blog and is showwing thia error
Do you image why?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@alessandramaced ,

You should have three parameters to pass to the flow. I also assume you are using a SharePoint Document Library.

The file name

The Base64 Text

The Identifier of the record in SharePoint the image belongs to.

Did you follow the steps for the Flow (particularly 2 & 3)?

The SharePoint Create File action selected and the Site and Folder chosen

Ask in Power Apps chosen for both the File Name and File Content

Delete the File Content reference and replace with the Expression
base64ToBinary(triggerBody()['Createfile_FileContent'])

Next step - SharePoint Update File Properties with Site and Library chose

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
alessandramaced 308 on at

Like
a
(0)

Report
Copy link

Link copied!

@warrenBelz

@WarrenBelz

here is my bottom :

With(
{
vJSON:
With(
{
vJSONI:
JSON(
First(colPhoto).Url;
JSONFormat.IncludeBinaryData
)
};
Mid(
vJSONI;
Find(
",";
vJSONI
) + 1;
Len(vJSONI) -
Find(
",";
vJSONI
) - 1
)
)
};
'Foto-Powerapps'.Run(
NomeFoto.Text & ".jpg";
vJSON;
Gallery3_1.Selected.Idend
)
)

The error is in red part.
Foto_Powerapps is my flow:

Data_image is a library in sharepoint where will be the taken and uploaded photos :

Gallery_3_1 is gallery in powerapps form.

My screen is powerapps:

I really don't know what is wrong.

Do you know what it is?

regards
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@alessandramaced ,

You have not followed the process where highlighted

The data is an Expression - you need to (as noted last post)

Ask in Power Apps chosen for both the File Name and File Content

Delete the File Content reference and replace with the Expression shown
base64ToBinary(triggerBody()['Createfile_FileContent'])

Your result will look like this (ignore the highlighted comment - it is only to show the expression content).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
alessandramaced 308 on at

Like
a
(0)

Report
Copy link

Link copied!

Now it did great. It was a problem if translation in automate.
Thank you very much!!!