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.

Categories:

Building flows

All responses (10)

Answers (0)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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?
tdwils 100 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Here is what I have so far:
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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
tdwils 100 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Is there something I am missing?

Thanks!
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
tdwils 100 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
tdwils 100 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mira_Ghaly- do you have any additional suggestions?
tdwils 100 on at

Like
a
(0)

Report
Copy link

Link copied!

Does anyone have any additional suggestions?
Eriniye1018 9 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Ui2 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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