Skip to main content
Community site session details

Community site session details

Session Id : bkZWcFq0q1H0rfbO8XooU1
Power Automate - Using Flows
Answered

Filtering Data and adding filtered data to Excel Table

Like (0) ShareShare
ReportReport
Posted on 31 Dec 2021 07:14:19 by 8

Hello,

 

I have a sharepoint list in which I would like to pull specific data from that list and add it on an Excel Table.

NGN1_0-1640934123918.png

 

What I would Like to do is to pull the rows from the list whenever the plant type says "Pellet" and create a row in an Excel Table. Once this happens, I would also like the flow to check if the ID number exists in the excel table so that if I need to update the list, it can update the existing row in Excel and not create a new row.

 

NGN1_1-1640934387455.png

This is my Flow

 

NGN1_2-1640934423045.png

The Excel table is called "IncomingPellets"

 

NGN1_3-1640934524483.png

NGN1_4-1640934580686.png

NGN1_5-1640934601655.png

 

At the moment the flow drops "pellet" and "Teen" data from the list into the "IncomingPellets" table and updates without creating duplicates. I am just not sure what else to include into the flow so that only the "pellet" items drop into the table.

 

I am fairly new to automated flows and have been stuck on this for days so please help!

 

 

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 03 Jan 2022 at 04:02:52
    Re: Filtering Data and adding filtered data to Excel Table

    Hi @NGN1,

    I think you should add another condition to check if the current item has a planting type with "pellet".

    Please just add a condition as below and it will only run based on it:

    vqiaqimsft_1-1641182515556.png

     

    vqiaqimsft_0-1641182419904.png

     

  • NGN1 Profile Picture
    8 on 31 Dec 2021 at 20:04:51
    Re: Filtering Data and adding filtered data to Excel Table

    Update:

     

    I added an array above the first array to filter data only containing the text "pellet. The flow now adds and updates pellets into the correct table. The issue now is that "Teen" still flows and duplicates. This has something to do with my condition where I say if the array is empty, add a row. Since I am filtering the data, whenever I update a teen row, the flow creates a new row. How can I fix this to where it does not add to the table?

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete