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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,511)