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

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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