Delete an item in another SharePoint list

(0) Share

Report

Posted on by tdwils

100

Hello,

I have 2 SharePoint lists (in different libraries). They are both staff directories. We will call them list A and list B. I want to build a flow that does the following:

When an item is deleted from list A (for example, someone is retiring so they need to not be on the directory), the flow looks at list B, finds that same person, and deletes them from list B.

I have tried with no luck to build this. I keep getting blank returns in the body output.

Thanks for any help.

I have the same question (0)

All responses (10)

Answers (0)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Delete an item in another SharePoint list

@tdwils

Can you please advise what is the common column between List 1 and List 2, or if you can share a sample of how your lists is structured?

Was this reply helpful? Yes No
tdwils 100 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

Sure thing. Both use a column called "Person TEST." They are both Person/Group type.

Here is what I have so far:

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Delete an item in another SharePoint list

@tdwils

Please use below in the OData filter:

Requested_x0020_By/EMail eq 'Email'

Requested_x0020_By is your person column

That should work , Let me know if you need more help

Was this reply helpful? Yes No
tdwils 100 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

Hi @Mira_Ghaly - thanks! But it doesn't look like Email is an available option:

Is there something I am missing?

Thanks!

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Delete an item in another SharePoint list

@tdwils

Opps sorry it is something I am missing..Because your trigger is on when an item is deleted , so you have no way of accessing the values of the item because flows are asynchronous, the only way here I see if you can use a new field on List 1 Delete Yes/No and then your flow should run on when an item is modified and if the value is yes , Get the item from List 2 first and the Delete Item in both List 1 and List 2.

Was this reply helpful? Yes No
tdwils 100 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

Hello @Mira_Ghaly - I went ahead and tried your suggestion and I still cannot get it to work. I created the new yes/no column, added the condition, and asked it to retrieve/delete the items. 1) it keeps saying the expression is false and that's where it ends. 2) it wants to put one of my delete items in the "apply to each" box.

Was this reply helpful? Yes No
tdwils 100 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

@Mira_Ghaly- do you have any additional suggestions?

Was this reply helpful? Yes No
tdwils 100 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

Does anyone have any additional suggestions?

Was this reply helpful? Yes No
Eriniye1018 9 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

I have made something similar and for me it worked.

If you have 2 sharepoint lists show the ID column in list B and create a column called 'code' in list A.

now what you need to do is make sure that whatever the ID number is in column b goes to the 'code' column of list A.

Then,

In your get items filter query put ID eq 'Code'

In your condition value put - length('Code") equals to 0

then in the YES part

Delete Items - Your List B - ID

Was this reply helpful? Yes No
Ui2 2 on at

Like (0)

Report

Re: Delete an item in another SharePoint list

Did you start like in the picture above with "When an Item is deleted"
then "Get Items"
compare ID eq theOderIDinTheList

Apply to each -> Condition: - length('theOderIDinTheList") equals to 0 ?

yes -> "Delete Items -> B -> ID

No -> nothing happens ?

Could i also use the following in the Condition -> if Title equals TitleFromOtherList?

Could you share your Workflow? Thanks a lot

Was this reply helpful? Yes No