Hello all. I'm a bit of a noob regarding power automate and i'm trying to learn.
I've been tasked to create a form and link the information on a sharepoint list in a workgroup. So far, everything work but if a customer choose to upload more than one picture, when the e-mail is sent, if for example 4 pictures are sent, there will be 4 e-mail sent instead of one with the link of the picture in sharepoint.
Can someone help me or point me in the right direction in order to send only one e-mail with the link in the body for all the pictures uploaded?
Here's is a preview of my flow below.
Solved! Go to Solution.
Hi @Axxellz ,
The point is to create a string instead of using an array.
If you use an array in 'Apply to each' action, you will send emails in bulk.
I did a simple demo for you.
items('Apply_to_each').Value
Best Regards,
Wearsky
Hi @Axxellz ,
The point is to create a string instead of using an array.
If you use an array in 'Apply to each' action, you will send emails in bulk.
I did a simple demo for you.
items('Apply_to_each').Value
Best Regards,
Wearsky
Hi Wearsky.
So you created an array and put a string on each elements in orded to send it as a string? Is that correct?
For your information, when i created my flow, i initialized a JSON variable in order to get the HTML link of my pictures. Maybe i should have mentionned this before. I will post it in order to show you. That's where the "link" variable is from on my first picture that i posted.
Is it possible to link my HTML link on the array with my JSON variable?
I`m trying to make it work but without any luck 😞
I did a bit of research and managed to receive an e-mail with multiple attachments when some items were created manually on my sharepoint list. But when i submit my form, there is no files attached on my e-mail. I followed this tutorial for sending an e-mail with attachments : https://www.youtube.com/watch?v=ehX_EE8wszs .
I created 2 flows for my problem, one for adding elements on my sharepoint list when the form is submited and the other one is for sending an e-mail with the attached files. Maybe i can incorporated them later on once i figure this thing out... But for the time beeing, i will focus on my form's flow since i think i know where the problem is.
I think the problem is when the form is submited there is no attachment files linked to my sharepoint list. Hence why no attachment are sent with the e-mail. I'm feeling that i am so close to solve this thing! Can you help me figure it out? There is no files sent with my an e-mail when the form is completed. Only when i add the files manually on my sharepoint list.
Here is my flow for my form when element are created on my sharepoint list. The part highlighted in yellow are the section where the user car send pictures. I just need to put an attached file on that section highlighted in yellow so that my other flow can be trigerred correctly in order to send an e-mail with the files.
User | Count |
---|---|
89 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |