I'm creating an app in PowerApps and in one use case I need to save images to the Azure SQL DB (which I'm using as storage). I read on the forums that this is not possible out of the box.
This is what I get when I try to save the image using Patch (column type in SQL Azure DB is "Image") - Tested from AddImage component and PenInput.
What does this actually mean and what are the alternatives?
Yes, currently this is not available.
See this thread:
Response from Staff archanan:
Support for uploading images to SQL is not currently supported. However, it's on our roadmap and we are working on adding this functionality.
The error message means the data type don't match. Actually the AddMediaButton.Media property would only offer the local Blob information (URL) for the image uploaded, and showing it in URL format with the image path, which then is a string format.
There is no alternatives that I can offer at the moment.
Thanks for your reply, going to ask the same question? Where are we on this? Any progress?
What is the best datasource today to persist images?
Would also like an update on this, even if it just allows us to save images as base64 it at least gets the data out of the local machines collections and into storage.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand