cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steventhi
Frequent Visitor

Unable to Ingest Sharepoint Form Attachments into Sharepoint List

In my sharepoint form, the last question allows my users to upload attachments (intended to be images). I've created a sharepoint list with columns to correspond with each question.

 

In flow, the "Create Item in Sharepoint" does not display any of the fields for my attachment/image ...

 

Here's my list in Sharepoint. Note, the first row with the user image on the far right is what I'm trying to accomplish through flows. However, even a hyperlink would suffice.

 

And also, when I try to forward off the approval workflow using the input directly from the forms, instead of a picture/attachment, I'm getting a code snippet. How is this corrected?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yiwenxie-msft
Microsoft
Microsoft

Hi @steventhi 

 

I’m afraid currently, user cannot update an image column in a sharepoint list using sharepoint connector except http request.

But user can add attachment to sharepoint list using sharepoint connector easily.

So the workaround is to add attachment to sharepoint list.

 

If user wants to add attachment, then he will need to get the ‘file content’ which he cannot get by the dynamic content of the answer in Form.

Actually, if a user upload file in MS Form, then the file will be automatically saved in OneDrive of the creator of the Form. So user can get ‘file content’ using OneDrive connector.

 

The following flow is for your reference:

3.9-2.PNG

 

The detailed steps for ‘Compose2’, ‘Get file content’ and ‘Add attachment’:

3.9-3.PNG

The two expressions are connected with a dot between them in ‘File’ in ‘Get file content’:

json(outputs('Compose_2'))[0]['driveId']

json(outputs('Compose_2'))[0]['Id']

 

For more info about the functions used:

json()outputs().

[0] is used to get the first item in an array, [1] is used to get the second item in an array, and so on.  

 

The dynamic content ‘File content’ in ‘Add attachment’ is from ‘Get file content’.

The ‘File Name’ in ‘Add attachment’ should contain the file extension, which in this case should be ‘.png’.

The same applies to the step ‘Start and wait for an approval’:

3.9-4.PNG

 

If you still have the problem, please feel free to let me know.

 

Best Regards,
Community Support Team _ Kira Xie
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

3 REPLIES 3
v-yiwenxie-msft
Microsoft
Microsoft

Hi @steventhi 

 

I’m afraid currently, user cannot update an image column in a sharepoint list using sharepoint connector except http request.

But user can add attachment to sharepoint list using sharepoint connector easily.

So the workaround is to add attachment to sharepoint list.

 

If user wants to add attachment, then he will need to get the ‘file content’ which he cannot get by the dynamic content of the answer in Form.

Actually, if a user upload file in MS Form, then the file will be automatically saved in OneDrive of the creator of the Form. So user can get ‘file content’ using OneDrive connector.

 

The following flow is for your reference:

3.9-2.PNG

 

The detailed steps for ‘Compose2’, ‘Get file content’ and ‘Add attachment’:

3.9-3.PNG

The two expressions are connected with a dot between them in ‘File’ in ‘Get file content’:

json(outputs('Compose_2'))[0]['driveId']

json(outputs('Compose_2'))[0]['Id']

 

For more info about the functions used:

json()outputs().

[0] is used to get the first item in an array, [1] is used to get the second item in an array, and so on.  

 

The dynamic content ‘File content’ in ‘Add attachment’ is from ‘Get file content’.

The ‘File Name’ in ‘Add attachment’ should contain the file extension, which in this case should be ‘.png’.

The same applies to the step ‘Start and wait for an approval’:

3.9-4.PNG

 

If you still have the problem, please feel free to let me know.

 

Best Regards,
Community Support Team _ Kira Xie
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

Hello Kira,

 

Thank you for your solution! This is working great

Hello,

I am new to powerapps - i've been reading your answers.

I have a sharepoint list and users can upload photo (via the attachment functionality). They can upload multiple pictures.

How can i display these pictures in a mail or html table (to be sent by email when a new item is created in sharepoint).

I'm currently able to display everything except the photos...

 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,588)