web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using conditions with ...
Power Automate
Unanswered

Using conditions with an Excel File list, but need to stop when True

(0) ShareShare
ReportReport
Posted on by 75
Using "Condition Control" vlookup in Excel but message repeat
yesterday

Hi all, thank you for all the help !, I was wondering if anyone can help me. I have this flow which main purpose is to take a message from a specific group chat, OPP-XXXXXXXXXX, then it will do  vlookup in a excel file and provide details of that deal such as: Date, Amount, Approved by.

 

Final Result:

Robotech12_0-1694712616538.png

 

 

Now I want to add an option that if that specific OPP is not in the list that it shows a message: "this opp is not tracked"; here below is my flow but I am sure I have something missing because when I run it the flow goes through the excel list (not just 1).

 

Robotech12_1-1694712616836.png

 

 

 

Flow Step:

 

Robotech12_2-1694712616808.png

 

 

 

Robotech12_3-1694712616545.png

 

 

Robotech12_4-1694712616529.png

 

 

I believe I am missing a step between from Condition and Lists Row Present Table to just get the specific details.

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Robotech12 I uploaded a YT Tutorial that goes through how to look up information on an Excel file and return it back to Power Virtual Agents. You need to use a Filter Array action instead of an Apply to Each and Condition action.

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard