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 / Copying a row to anoth...
Power Automate
Unanswered

Copying a row to another worksheet based on a criteria

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Everyone, 

 

I need some help so I’m not sure if its possible but I’m trying to set up a power automate flow where I would like a row to be copied on other worksheets depending on the selection or criteria. For example I have if the candidate has yes on the recommended column then I would like for it to go to the recommend worksheet but if its a no or withdrew then they would go to their own worksheet. Here’s an image for an example. I would really like to use power automate cause I don’t want formulas in the other worksheet cause I’m want people to work on the other worksheet once they receive that information. 

 

Thank you, guys

 

0D684774-7238-4F23-AED7-88E1E320EFA0.jpeg

I have the same question (0)
  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Use a switch case and say:

    case yes go to subflow Yes

    case No go to subflow no

    and then in each respective subflow, tell it what you want it to do. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    That only worked for me when its going from Microsoft form to excel workbook but it doesn’t work when its excel worksheet to excel worksheet. 

  • MichaelAnnis Profile Picture
    5,727 Moderator on at

    Apologies. You are on the Power Automate Desktop (PAD) Forum. I didn’t realize you are using Power Automate flows. In PAD, we have fairly decent function in Excel. Apologies, you may want to try the general power automate forum. 

    good luck!

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I'm so sorry I wasn't aware there were different ones thank you so much for that information. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard