¡HELP! - I CAN'T GET THE FILE CONTENT USING PATH FROM A RESPONSE OF MICROSOFT FORMS

[gflopez]

Hi Wonderfull community!

I am trying to get the file from a response in Microsoft Forms. Then I want to send it as an attachment in a Email. It is used to grade students from a course. Thanks God, I found a video that does the same but with a SharePoint Drive! Look at it here: From minute 29:30 How to save Microsoft Forms Responses & Attachments to SharePoint Lists or Libraries & Send Email - ...

I am retrieving the file using a similar action to the presented on the video but with OneDrive. It only requires the link, so I put this assertion on the Loop:

item()?['link']

However, I am getting this error:

As you may see I could retrieve the link, but there we have the error.  Do you know what this error is about? I don't have too much info from the output. If you need more information, tell me I will update this entry...

EDITS:

Edit 1: I upload a screenshot of the flow and make a grammatical revision of this post...

I will send the screenshot then I explain what does it does for each action:

1. "Cuando se quiere enviar" is the trigger for the flow. It activates when I receive a response from Microsoft Forms to this private survey:

I'm still building... So some parts as question 4 and option B of 2 are not being used already.

2. "Obtener ingredientes" retrieves the details from the received response on Microsoft Forms

3. "Creamos actividad" gets the value from question 1 of the response and saves it as a String. I used dynamic content

4. "Creamos Correo Destinatario" gets the value from question 3 of the response and saves it as a Strin.  I used dynamic content

5. "Creamos Nombre Destinatario" it is an empty String for now. Since the name of the person is saved on the file name which is uploaded on question 5.

6. "Creamos Adjuntos" Creates an empt array that we will fill with the attachments for the email. In this case we only need one.

7. ¡Let's go to "Aplicar a cada adjunto"!

I will explain. The dependence is on the uploaded part from the question 5. As far as I understand, it works as an array but we need to convert it to a manageable one for Power Automate (it is said on the video). To do it we put the following expression as the thing we are going to loop over and over:

json(outputs('Obtener_ingredientes')?['body/r2b0ebf07dc534414b0b2ad64629d7996'])

7.1 "Obtener el contenido del archivo mediante ruta de acceso" Gets the onedrive file from a path. To get the path we use the link from the file uploaded to the response (Suggested by the video): It is the expression I used:

item()?['link']

7.2 "Establecer variable" gets the file name with a similar process of the above 7.1. It is the expression I used to get the name and assign to my variable we created on 5:

item()?['name']

7.3 "Anexar al arreglo de adjuntos del correo" for every item creates the file we will attach by usign the format for emails. This strategy was also suggested by the video. It is the expression I used...

{
"Name": "R_@{variables('actividadCalificada')}_@{item('Aplicar_a_cada_adjunto')?['name']}",
"ContentBytes": @{body('Obtener_contenido_de_archivo_mediante_ruta_de_acceso')}
} 

Finally, we sent the email by joining all the ingredients together. However, I don't get here already because of the flow error.

[creativeopinion]

Can you upload a screenshot of your full flow?

[trice602]

Hi @gflopez ,

Here's the solution I just tested it.   Copy this from your response details.

Add a parse json and use the copied JSON above as your scheme.

In your email, select the link in your email body.  Please mark as a solution if this helps!  Always glad to help! Tom

[gflopez]

Hi @creativeopinion ! I updated the post. Look for it again. I hope it helps...

[trice602]

Hi @gflopez ,

Here's my form and flow.  To get the link you have to add PARSE JSON first.  Please see me previous post to walk you through getting the right scheme in there.  Again, this works in my test and I can get the attachment link and email it.  Always glad to help! Tom

[gflopez]

Oh @trice602 ! I never considered creating a link that goes to the file I uploaded. Let me implement it... I will tell you what happens soon.

[trice602]

Nice @gflopez  - let me know when you have this working, please mark as a solution.  Always glad to help! Tom

[gflopez]

Hi! @trice602... May you send a complete picture of the code we use on JSON. I am not sure where to include commas and {}

[trice602 · Accepted solution]

Hi @gflopez ,

Please following the steps from my original response added here.  I will repost it again here.

Step #1:

In your last failed run, look at the output from GET RESPONSE DETAILS and look for the question that asks for a file upload.  In my example, my question was "Add a file".  You don't need to worry about the format.  Simply copy the JSON from this output as shown in this example below.

Step #2:

Add a Parse JSON action.  Reference the question from your form.  In my example, I am referring to the question "Add a file" as shown below.  NEXT CLICK ON GENERATE FROM SAMPLE BUTTON, PASTE IN THE JSON FROM THE PREVIOUS STEP.

Your scheme will look similar to this.

Step #3:

Add a Send Email (V2).  This will automatically get wrapped in an Apply to Each when you add the Link from the Parse JSON action from the previous step.  Verify your email test looks exactly like this.

Please follow these steps, save and resubmit or test.  You will receive an email with the link to the attachment in OneDrive.  Please mark as a solution, always glad to help! Tom

[Lyn123]

Hi Sir, I am trying to use "get response details" output to get sample to generate parse json, but I find what I could get is different from yours, there is no separate item for "attachment, but all the information is combined in "Body", so I cannot generate parse json standard value, could you help me fix this problem? Many thanks!

[trice602]

Hi @Lyn123 ,

Switch to classic to see the same format in my example please.

[Lyn123]

Hi Trice, thank you so much, my problem has been resolved!