cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndreaPRJ
Frequent Visitor

Save the photos taken by a camera control in an excel file

Goodmorning everyone.

With my Powerapp, which already saves data in an excel file in my One Drive, I'd like to add a camera control and save one (only one) image/photo for each record saved in excel.

I tried in 2 ways:

  1. I First tried to do a patch...
  2. Then I followed these tips, using a collection and First value: Solved: Re: Saving captured image to excel - Power Platform Community (microsoft.com)

 

but then at the end in the excel file I see always in the "Image [Image]" column some strange strings (*) and I don't understand where I am going to save the photos !! (although in truth I can see the photos inside the app!).

I was expecting at least to find in my OneDrive a subfolder with the images inside, but it isn't ..


where is my app saving photos?

 

Thanks in advance

Bye

Andrea

 

(*) "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAeAAAAKACAYAAABEyKtSAAAAAXNSR0IArs......................."

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @AndreaPRJ :

These strings are actually the pictures you saved, they are file content in Base64 format.

Base64 is an encoding algorithm that converts any characters, binary data, and even images or sound files into a readable string, which can be saved or transported over the network without data loss. ... Base64 images are primarily used to embed image data within other formats like HTML, CSS, or JSON.

I've made a test but did not encountered the problem you mentioned:

1)create an excel file , insert a column named Image[image]

format data in excel as a table

upload this excel file to one drive

vbofengmsft_0-1639726169081.png

 

2)connect your app with the excel table in one drive

3)insert a Add picture control

4)Add a button control and set it's OnSelelct property:

Patch(Table2,Defaults(Table2),{Image:UploadedImage1.Image})

The Result:

vbofengmsft_1-1639726188523.png

vbofengmsft_2-1639726193948.png

I think this link will help you a lot:

Take Photo and Upload to OneDrive 

Best Regards,

Bof

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,834)