Unable to Ingest Sharepoint Form Attachments into Sharepoint List

[steventhi]

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?

[v-yiwenxie-msft · Accepted solution]

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:

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

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’:

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.

[steventhi]

Hello Kira,

Thank you for your solution! This is working great

[AOZ]

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...