cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NotaTechGuy
Frequent Visitor

Delete Items from SharePoint list when not in excel

I have a flow to create and update SharePoint list items based on a rows in an excel table, this works perfectly.  What I am trying to do now is create another flow to delete these SharePoint items when their corresponding row is now longer present in the Excel file.

 

I have tried adapting the example that @v-alzhan-msft suggested in this post Deleting item from specific Sharepoint list upon Master list delete but it deletes everything but the records I am trying to delete.

 

Please, please, please could somebody tell me where I am going wrong..  My example is below 

 

Pic1.pngPic2.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hey @NotaTechGuy 

 

So understand it like this: 

 

Get rows from excel and identify a unique column based on which you want to check the SP list. Now create an array variable and populate this array with the unique columns. (List rows from table-> apply to each value-> append to array variable)

 

Now, out of the loop add an action to get items from the SP List. Apply to each SP item, add a conditon and in this check if that array contains the field from the SP list. If it contains, all good and if not, delete that item. 

 

The blog article was just to reference existence of an element in a data source and it can help you in this scenario that you are building. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

10 REPLIES 10
yashag2255
Dual Super User II
Dual Super User II

Hey @NotaTechGuy 

 

In the current flow, you are getting all the items that match the title and then deleting those-> that means delete all the items in sp where the tiel matches the column in excel. 

 

In the filter query, can you try updating eq with ne?

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Hi @yashag2255 ,

 

I changed the filter query to ne and that deleted all records?  Could it be the logic in the condition?  I copied the example 

length(body('Get_items')?['value']) is greater than 0
 
Thanks for helping me out. 
 
 

Hey @NotaTechGuy 

 

I just noticed. We are doing it all wrong. So the List Rows is getting us data from excel and then we are checking for a particular row item in SP list and then deleting the ones if that is not found (so this is bascially deleting all items other than the particular row item not the entire column). 

 

To get rid of this, you need to create another array variable and get all the matching items in that and based on that delete the items from the SP list. You can follow this article here to check the approach of adding the items to an array and then comparing with the list before deleting: https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Delete-duplicate-records-items-fro...

 

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Thanks @yashag2255 , I am trying to adapt your example now.  I cant see how the "test"array gets it's values though..  You reference it in the condition, then append the results?? How does it get the values to check in the condition? As you can see I am a super non technical user, just trying to advance from using multiple versions if an excel file 🙂

 

 

Hey @NotaTechGuy 

 

So understand it like this: 

 

Get rows from excel and identify a unique column based on which you want to check the SP list. Now create an array variable and populate this array with the unique columns. (List rows from table-> apply to each value-> append to array variable)

 

Now, out of the loop add an action to get items from the SP List. Apply to each SP item, add a conditon and in this check if that array contains the field from the SP list. If it contains, all good and if not, delete that item. 

 

The blog article was just to reference existence of an element in a data source and it can help you in this scenario that you are building. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

GOT IT!  Thank you so much @yashag2255 

 

 

Tyson
Frequent Visitor

I @yashag2255 yash, I was trying to acheive something really similar. Could you please provide some support on how can this be achieved?

 

Regards

Tyson

Tyson
Frequent Visitor

@yashag2255 Hi Yash,

 

 

I figured it out! You are a legend!

 

 

Regards

Tyson

Thank you very much for taking the time to post the solution; it works!

Hi @yashag2255 ,

 

I am trying to figure it out but without solution.

 

I wanted to delete the items in Sharepoint once they are deleted in excel.

 

Can you show me please some screenshots?

I am not a good programmer.

I was able to update and create from excel, but I cannot delete the items.

 

Please, I repeat Please, show some screenshots.

 

Thanks in advance.

Matteo.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,405)