cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to use images stored in SQL Server

Hi all!

 

I have an application that stores the user's signature in SQL, in a image field.

Firmas.png

In SQL (stored the signature):

FirmasSQL.png

But, it doesn't appear in the app after...

Show.png

Can you help me?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: How to use images stored in SQL Server

Hi @gabrielv22 ,

Could you please share a bit more about your issue?

Do you want to display the image data from your SQL Table into the Gallery in your app?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:15.JPG

The data structure of my SQL Table as below:16.JPG

 

On your side, if you use Gallery control to display records from your SQL Table, please set the Image property of the Image control to following formula:

ThisItem.ImageField

If the issue still exists, please consider remove the Image type field from your SQL Table, instead, add a varchar(max) type column in your SQL Table to store the uploaded PenInput image.

Please check and see if the following video resource would help in your scenario:

https://www.youtube.com/watch?v=QnDD7jleHME&feature=youtu.be

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Helper II
Helper II

Re: How to use images stored in SQL Server

For me it seems that the signature is stored as base64 string, but does not contain the appropriate label. 

Consider putting "data:image/png;base64" in front of your SQL Data. 

 

e.g.
image.png

 

 

 

 

 

where "MySignature" is your SQL data lookup. 

 

Kind regards 

Lars 

Highlighted
Community Support
Community Support

Re: How to use images stored in SQL Server

Hi @gabrielv22 ,

Could you please share a bit more about your issue?

Do you want to display the image data from your SQL Table into the Gallery in your app?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:15.JPG

The data structure of my SQL Table as below:16.JPG

 

On your side, if you use Gallery control to display records from your SQL Table, please set the Image property of the Image control to following formula:

ThisItem.ImageField

If the issue still exists, please consider remove the Image type field from your SQL Table, instead, add a varchar(max) type column in your SQL Table to store the uploaded PenInput image.

Please check and see if the following video resource would help in your scenario:

https://www.youtube.com/watch?v=QnDD7jleHME&feature=youtu.be

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,889)