Filtering Data and adding filtered data to Excel Table

(0) Share

Report

Posted on by NGN1

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.

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.

This is my Flow

The Excel table is called "IncomingPellets"

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!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

NGN1 8 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No