Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

excel cell value (3 options) send email based on condition

Like (0) ShareShare
ReportReport
Posted on 15 Sep 2020 13:36:09 by 77

I have an MS Form feeding an excel sheet.  I have one column called "Theatre" where the region choices in the form are Americas, APAC or EMEA.

 

I added a column in the excel called "Flow Triggered" where the choice is Yes or No to avoid a loop scenario.

 

The aim:

 

  1. If cell = Americas, send email to person A and change Flow Triggered cell to Yes.
  2. If cell = APAC, send email to person B and change Flow Triggered cell to Yes.
  3. If cell = EMEA, send email to person C and change Flow Triggered cell to Yes.

DarrenPlant_0-1600176042548.png

Added a delay before calling a "list rows in a table" action.

 

Then added a "Apply to each" control

DarrenPlant_1-1600176264257.png

 

The "Update a row" above in the "If Yes" based on condition should change the row cell to "Yes" for the column "Flow Triggered".

 

Issues: The update a row works, but it did not deliver the flow adaptive cards........

 

Can someone please advise my logic so I can avoid any loops and so it works properly!

  • DarrenPlant Profile Picture
    77 on 17 Sep 2020 at 07:40:16
    Re: excel cell value (3 options) send email based on condition

    Thankyou @v-litu-msft this helped me 😎

     

    DarrenPlant_0-1600328402802.png

     

  • Verified answer
    v-litu-msft Profile Picture
    on 16 Sep 2020 at 06:30:23
    Re: excel cell value (3 options) send email based on condition

    Hi @DarrenPlant,

     

    I read your Flow logic, and it won't have a loop. To make it work more perfect and make Flow more graceful, you could consider using the Switch control instead of three condition action to determine the "Theatre", for example:

    Screenshot 2020-09-16 142833.jpg

    It will go to the corresponding branch according to the Theatre value.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2