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