Pictures from MS Forms in Sharepoint and from Sharepoint populate Excel

[LucaNeedHelp]

Hello everyone,
I am currently working on a flow that pushes a survey from Forms with normal text answers into a Sharepoint list and fills an Excel table from this Sharepoint list and sends it by mail. This works so far in two different flows. Now, however, an attachment or image should also be sent. Does this have to be done with JSON or Base64?
Here the first flow:

Here ist the second Flow:

[v-jefferni]

Hi @LucaNeedHelp ,

You're correct! You need to use parse JSON to get uploaded file id in OneDrive, use the id to get file content and use the file name and content as the attachments of Email. May I know about the upload image questions in the survey, how many images are allowed to upload in a single question? 

Best regards,

[LucaNeedHelp]

Hi @v-jefferni ,

just one document. 

Thank you for your help!

[LucaNeedHelp]

and @v-jefferni how i get the Attatchment to the Sharepointlist? Which categroie is the attachment in the Sharepointlist? Because i dont get it. Sorry i am new to this power automation!

[v-jefferni]

Hi @LucaNeedHelp ,

You need a Add attachment action which uses the file name and content as well to create attachment to the recent created list item.

Best regards,

[LucaNeedHelp]

In which flow? For the sharepoint? Or for sending the mail?

[v-jefferni]

Hi @LucaNeedHelp ,

Actually, I think you just need one flow. You can move all actions in the second flow to the first flow, anything you need from the trigger of the second flow you can find them return from Create item action as well. The Add attachment action should be placed anywhere just under the Create item action.

Best regards,

[LucaNeedHelp]

But it do not work to get the attachmednt in to the sharepoint list. 

[v-jefferni]

Hi @LucaNeedHelp ,

It should work, unless something is wrong in the flow. Is there any error? How did you setup the Add attachment action?

Best regards,

[LucaNeedHelp]

Hi @v-jefferni ,

No, the problem is that I can't get the attachment into Sharepoint as an extra column. If I use it as a column, it tells me that I can only use 255 characters and the links are too big. So the question for me is do I have to display the attachment in the sharepoint list at all or how do I get it in here?

[v-jefferni]

Hi @LucaNeedHelp ,

I was saying the action:

it adds a file to the item of Create item action in default Attachments column.

Best regards,

[LucaNeedHelp]

hi @v-jefferni ,

I think we're talking at cross purposes, or I don't understand. Sorry.
The flow is there to load the answers into the sharepoint once and then fill all answers into an Excel template. The attachment from the Forms survey should also be added to this template. This is my current problem.

[v-jefferni]

Hi @LucaNeedHelp ,

I understood. You can create share link for the file saved in OneDrive and populate the URL in a Hyperlink column in the list, also the URL can be used to populate Excel table.

Best regards,

[LucaNeedHelp]

but it comes always another file that came from the forms

[v-jefferni]

Hi @LucaNeedHelp ,

I don't know why, unless you used the wrong file id in these OneDrive actions.

Best regards,

[LucaNeedHelp]

i give up for today! 🙂 I don´t know.

[v-jefferni]

Hi @LucaNeedHelp ,

Please post some screenshots of the flow in edit mode so that I can try and figure out if there is a mistake.

This is my flow to get the file id from outputs of Parse JSON action

Best regards,

[LucaNeedHelp]

here is the full flow 1 & 2:

Flow 2 From Sharepoint to Excel Template to Email

Flow 2Flow 2

Flow 1 From Forms to Sharepoint:

Flow 1Flow 1Flow 1

[LucaNeedHelp]

Hi @v-jefferni , did you find a solution? 🙂

[v-jefferni]

Hi @LucaNeedHelp ,

This is the overview of the flow I have created based on your workflow logic:

In the Create item action, you can see I'm able to connect to the result of Parse JSON using the expression:

first(body('Parse_JSON'))['link']

In initialize variable 2, the input values are from the outputs of Create item. The returned values are exact the same as the trigger "When an item is created" if they are the same list.

Best regards,