web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows How to filter data fro...

Power Automate - Building Flows

Answered

How to filter data from excel in cloud flow

(0) Share

Report

Report

Posted on by kiran_g

150

if there is "Completed" in a Status column then cut those rows and create a new sheet with the name of success & paste it into that sheet

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Re: How to filter data from excel in cloud flow

Sure.

First step is to "List Rows Present in Table" - so make sure your data is formatted as a table.

In that action, use the "Filter Query" Status eq "Complete"

Then, you'll just need to use "Create Worksheet", and then "Create Table", and then "Add Row into Table", and use the data from the "List Rows Present in Table" to populate it.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 659 Super User 2025 Season 2

#2

Tomac 386 Moderator

#3

chiaraalina 290

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans