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

Copy and Filter

Hi everyone, 

 

I could use some help building a flow! Here is the process that I'm struggling on. 

 

1. Grab excel sheet that is sent daily through an email

2. Open that excel sheet, and copy/paste that existing data into a new tab on the same file. 

3. In the new tab with the copied data:

  • Filter out "X" in column G
  • Filter out "Blanks" in column K
  • Filter out material that starts with "S" in column I

 

This would be a HUGE help!

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Bgfmsu ,

 

I did a test for you.

vxiaochenmsft_0-1633331674990.png

 

vxiaochenmsft_1-1633331709626.png

vxiaochenmsft_2-1633331720266.png

@and(not(equals(item()?['T7'], 'X')),not(startsWith('T9', 'S')))

vxiaochenmsft_3-1633331756384.png

vxiaochenmsft_4-1633331782023.png

 

The result is as follows:

vxiaochenmsft_5-1633331809891.png

vxiaochenmsft_6-1633331823433.png

 

Best Regards,

Wearsky

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @Bgfmsu ,

 

I did a test for you.

vxiaochenmsft_0-1633331674990.png

 

vxiaochenmsft_1-1633331709626.png

vxiaochenmsft_2-1633331720266.png

@and(not(equals(item()?['T7'], 'X')),not(startsWith('T9', 'S')))

vxiaochenmsft_3-1633331756384.png

vxiaochenmsft_4-1633331782023.png

 

The result is as follows:

vxiaochenmsft_5-1633331809891.png

vxiaochenmsft_6-1633331823433.png

 

Best Regards,

Wearsky

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,662)