Save image in another format(other than blob)

[Anonymous]

Is there a way to save an image to a database (excel or sharepoint list) in a format that is not "BLOB"

In my application, the user have to attach a picture and send it to me, I created a flow to send this to a sharepoint list, but it goes as (i.e): blob:A6A76A9F-CD67-4FDD-B217-<morelettersandnumbers> , The image is sent to sharepoint AND excel like this, already tried on both platforms.

Is there a way to save it on another format? Or maybe a way to convert the blob code into the image again?

Thanks,

[skmcken]

I hate Organizational Policies that reduce Productivity, lol

[maxtarneberg]

@skmcken

Yep, same reason I probably can't accept any files from you.

All I want is an app that takes photos and saves them with a filename, frankly anywhere - I've given up on being choosy!

It feels like MS are ignoring me and the issue @v-micsh-msft

How hard can it be!?!?

These templates aren't 'templates' at all, because they're unadaptable, therefore 'examples' is a better description.

[skmcken]

@maxtarnebergI'm surprised if your using Office 365, that Organization Polices would be blocking PowerApps, Flow and SharePoint. If they are, I would tell your Organization to relax the polices otherwise, they are missing out on huge productivity ROI.

[maxtarneberg]

@skmcken

...its a fine line between productivity and security...but yeah, flows seem to be blocked, and installing stuff is restricted (e.g. postman). Basically,  shifting to Sharepoint is a big investment, and it has been a less than smooth transition, so understandably, mucking about can make people edgy. 

[maxtarneberg]

@skmcken@v-micsh-msft@Anonymous

There was a simple solution to part of this.

Use OneDrive and excel table to record data.

Ensure column is named correctly i.e.:   Photos [image]

Before mine was named: Photos[Image]

Now images are successfully saved onto OneDrive, as Jpgs, into a folder with spreasheet updated accordingly.

Filename is still a mess, but a better reference can be recorded into the spreadsheet.

I will share the folder with my organisation, or maybe attempt a flow to rename the files using the data in the spreadsheet, and then copy/move to a sharepoint folder (?)

Thank you for the community support

[v-micsh-msft]

@maxtarneberg,

Apologize for the late response.

Save image from Camera control is not available for all data sources.

For Excel, the image could be saved in the way described in the article below:

https://docs.microsoft.com/en-us/powerapps/tutorial-working-with-images-in-excel

For SharePoint list, there is an idea submitted on this (status has been started):

https://powerusers.microsoft.com/t5/PowerApps-Ideas/Submit-captured-image-to-SharePoint-List/idi-p/2...

Within Excel, the image is saved as relative path, so I am afraid it will not work with a simple copy and paste from OneDrive into SharePoint folder.

Further, using custom API should be able to save the image data directly:

Some reference for you:

How to upload images from the Camera control to Azure Blob storage

Regards,

Michael