cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

issue with select in a apply to each loop

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

1.JPG2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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?

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

1 REPLY 1
Super User III
Super User III

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?

 





Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips, tricks, and guides
FlowAltDelete




View solution in original post

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (47,543)