cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
stapes
Level 8

How do I display images saved after using Add Picture control to upload it?

I am uploading a picture from my PC and saving it to a database, using the AddPicture control.

The image is saved in an SQL field defined as varchar(max).

This is the Save command:

SavePhotoToDB.Run(
    UploadedImage2.Image,
    glCurrentStCode,
    txtComment_1.Text
);
Notify("Picture Saved to DB");
Back();

Save SQL looks like this:

CREATE PROCEDURE [dbo].[SP_SS_SavePhotoToDB] 
	-- Add the parameters for the stored procedure here
	@photoImage varchar(MAX), 
	@photoLinkID varchar(20) = '',
	@comment varchar(100) = ''
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	


INSERT INTO [dbo].[TBL_SS_PhotoImages]
           ([PhotoImage]
           ,[PhotoLinkID]
		   ,[Comment]
		   ,[Timestamp])
     VALUES
           (@photoImage,
           @photoLinkID,
		   @comment,
		   GetDate())

SELECT SCOPE_IDENTITY()


END
GO

The actual data looks like this:

 

appres://blobmanager/cb639b02c97b4b308ac07a81f11cd8ae/1

 

When I read that back in using a flow & attempt to display it, there is nothing to see.

Why can't I see my picture?

1 REPLY 1
WarrenBelz
Level 8

Re: How do I display images saved after using Add Picture control to upload it?

Hi @stapes ,

Firstly, you might try looking at this video I saw some time ago from Shane Young @Shanescows as it possibly covers the issues you are dealing with.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

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