Send image to excel database

[Anonymous]

Hey guys!

I'm doing a subscription form. In order to do that, i have 2 text fields, 1 dropdown and 1 "send image" control. On the button I have a PATCH function doing all the job. The problem is that when you submit it, all data comes correct except for the image, it shows up on Excel as a link ( blob:https://create.powerapps.com/<LOTS OF NUMBERS AND LETTERS HERE> ) that when i click, goes to an 404 page(if I try without the BLOB: it shows up a series of number and letters also)

Any help?

Thanks!

[v-micsh-msft]

Hi @Anonymous,

Could you please explain a bit for the "Send image " control here?

Is this an image control,  Add Picture control or a  Camera control?

Besides, have you checked the following documentation for add images to Excel?

Add images to Excel from PowerApps

For the patch, could you please also share the formula you used ?

Regards

[Anonymous]

Hi @v-micsh-msft!

It's an Add Picture Control!

I Already checked the add images documentation, did it step by step and I still get the same thing. The problem is that the image shows up on excel as a link that cant be opened(gives me an error 404 on browser)

The Patch formula would be 

Patch(Table2; Defaults(Table2);{Email:TextInputEmail.Text; RE: Value(TextInputRE.Text);  Setor: Setores.Selected.Value; NomeCurso: TextBox1.Text; Comprovante:  AddMediaButton1.Media})

The Image control would be the last one, "Comprovante"

And in excel, the image shows up as 

blob:https://create.powerapps.com/<lots_of_number_and_letters_here>

[Meneghino]

Hi @Anonymous

You may find some clues in the following post, please let me know if you resolve the blob issue:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Solved-How-to-save-captured-images-in-SharePoint/td-p/19154

[Anonymous]

@Meneghino The post you sent me works for the camera control, I want for the add picture control, because the user is probably going send a print screen!