for each

(0) Share

Report

Posted on by Denilson

Hi i have a problem when i arrive at the for each flow anyone know what i can do

Categories:

Using flows

flow 7.png

flow 6.png

I have the same question (0)

All responses (6)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report
Hi @Denilson ，

Please try replace outputs('Filtrer_un_tableau')[body/value'] with body('Filtrer_un_tableau') in Create HTML table From:

body('Filtrer_un_tableau'):

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Denilson 12 on at

Like (0)

Report

Hi okey the flow work but when i get the mails i get to many mails not just one

Was this reply helpful? Yes No
CodrutFt 46 on at

Like (1)

Report

Hello,

you get these e-mail because you have a for each and probably you body is an array. Try to get only the first item using .First() of the body. You need to pay attention to what variables are you using inside Send e-mail. If you use the variables from the body to have the contact list, just do body("Filter_un_Tableau").First()?['Contact'](Something like this, you need to test the expression), where 'Contact' is just a guess of mine about what you are using inside "send e-mail" action.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Denilson ,

Please check this test.

Please switch to classic designer.

My SharePoint List:

My Flow Preview:

Flow Configuration Parameters:

item()?['Emailaddress'] union(body('Select'),body('Select'))

item()?['DueDate'] item()?['Status/Value'] item()?['ID'] length(body('Filter_array'))

join(body('Select_2'),';') join(body('Select_3'),';') join(body('Select_4'),';')

Inbox Email:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Denilson 12 on at

Like (0)

Report

hi
the flow is working now but everyday i get a new email instade of just geting one will it is the due date but i get emails everyday and i dont want it to come everyday but just when the equipement is getting to it due date

Capture d'écran 2...

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @Denilson ,

Please add the filter condition of whether the Due Date is equal to today's in Get items, and then check whether the length is greater than 0, and send the email only if it is greater than 0.

DueDate eq '@{utcNow('yyyy-MM-dd')}' length(outputs('Get_items')?['body/value'])

The Result:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No