Power Platform Community Forum Thread Details

i need help to store image from canvas gallery using add picture button to sharepoint list, because this app requires to be update on-the-spot using phone so i chose to use add picture button instead of camera. i already connect the gallery with my SP list as below.

the problem i encountered

1. my SP list column did not update the captured photo

2. i only able to patch if i used single function of addpicturebutton (not in gallery)

what i wish to do is

1. the add picture button will capture on the spot photo and store it in SP list column image3 in a hyperlink format

2. i want my SP list column image3 able to update image link based on gallery row

3. i want to patch the uploaded photo from my SP list column images on the next screen of my app

add picture.png

Categories:

Building Power Apps

Hi @hpyf ,

Do you want to patch the SharePoint list with the images?

Firstly ,I want to explain why you can not patch the image to the SharePoint list.

Since the data source is SharePoint, It is not feasible to update the Picture field with an image file in canvas app.

In addition, you can update Hyperlink field with URI.

SharePoint/Known issuesI think this link will help you a lot :

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

Finally, I have an idea here for your reference:

My Date Source:” List A”

Target:Save the three pictures in the collection to three files in a record of List A

1\Add a Add picture control(For testing purposes, I use picture control instead of Camera control)

2\Add a button.

OnSelect:

Collect(
 MyPics, /*create a collection to save the pic*/
 {
 DisplayName: Concatenate(
 "image",
 Text(
 Now(),
 "[$-en-US]yyyy-mm-dd-hh-mm-ss"
 ),
 ".jpg"
 ),
 Value: UploadedImage1.Image,
 AbsoluteUri: "",
 Id: "00000000-0000-0000-0000-000000000000"
 }
)

3\Add a Gallery

Items:

MyPics

4\Add a Form(Form1)

DefaultMode:

FormMode.Edit

DataSource :

'List A'

Item:

LookUp('List A',ID=1) /* Specify records to update */

set the attachments control’s Items property to: MyPics(Important!Refer to the picture attachment for detailed settings)

Visible: false /* Make the entire form invisible (beautiful consideration)*/

4\Add a button

OnSelect:

SubmitForm(Form1);
Patch(
 'List A',
 LookUp( /* Specify records to update */
 'List A',
 ID = 1
 ),
 {
 column1: First(
 LookUp( /* Specify records to update */
 'List A',
 ID = 1 
 ).Attachments
 ).AbsoluteUri/*patch the column1 field with the first pic's URI*/,
 column2: Last(
 FirstN(
 LookUp( /* Specify records to update */
 'List A',
 ID = 1
 ).Attachments,
 2
 )
 ).AbsoluteUri/*patch the column2 field with the second pic's URI*/,
 column3: Last(
 FirstN(
 LookUp( /* Specify records to update */
 'List A',
 ID = 1
 ).Attachments,
 3
 )
 ).AbsoluteUri/*patch the column3 field with the third pic's URI*/
 }
)