Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / Filtering Data and add...
Power Automate - Using Flows
Answered

Filtering Data and adding filtered data to Excel Table

(0) ShareShare
ReportReport
Posted on by NGN1 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
    v-qiaqi@microsoft.com on at
    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
    NGN1 8 on at
    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

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans