cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gabrielv22
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
v-xida-msft
Community Support
Community Support

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
Lars4
Helper II
Helper II

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 

v-xida-msft
Community Support
Community Support

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,394)