issue with select in a apply to each loop

[willy30870]

Hello,

I have a google sheet with multiple data: name, email, service1, service2, service3, date.
When the date is equal to the current date, I want to send an email with the value of services 1, 2 and 3 to the email in the spreadsheet.

So here is my flow :
This flow is launched every day.
1- I filter the data of a google sheet to retrieve all the rows having as value the current date with "filter array".
2- I use the "apply to each" loop on each row from step 1 to extract the value of each column of the selected row. And now I already have a problem for the first loop, the "select" retrieves the first data but for the second loop, the "select" retrieves the value of the first loop twice while the value of the variable seems to be correct.
Do you have a solution or another way to precede ?

Regards

[Jcook · Accepted solution]

Hello @willy30870 

What are you using the Select action for?

if you are using the select to grab the email address only, why not use a Compose action?