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!
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:
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?
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2