Loop not single Items

(0) Share

Report

Posted on by Giorgio67

145

CIAO

Ho un file Excel e devo inviare un'e-mail per ogni "ID corso" piuttosto che per singoli elementi o valori. Inoltre, devo inviare l'e-mail a tutti gli indirizzi all'interno del gruppo. In questo modo tutti vedono i destinatari

In questo caso devo inviare 3 mail.

Grazie mille

ID corso	Posta	Inizio	Fine	and so on	and so on
1_AAA	ttt@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_AAA	kkk@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_AAA	www@gmail.com	2024-04-10T09:00	2024-04-10T11:00
1_BBB	ttt@gmail.com	2024-04-11T09:00	2024-04-11T10:00
1_BBB	qqq@gmail.com	2024-04-11T09:00	2024-04-11T10:00
2_SSS	ttt@gmail.com	2024-04-12T09:00	2024-04-12T14:00
2_SSS	kkk@gmail.com	2024-04-12T09:00	2024-04-12T14:00
2_SSS	www@gmail.com	2024-04-12T09:00	2024-04-12T14:00

All responses (1)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Re: Loop not single Items

Hi , @Giorgio67

This is my test Excel file table:

You can refer to this flow.

(1)The Select action:

(2)Apply to each action :

union(body('Select'),body('Select'))
item()?['ID corso']
item()?['Posta']
join(union(body('Select_2'),body('Select_2')),';')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang