0

I was trying to update and delete items from multiple list based on sharepoint when an item is added to a master list. I was able to update a list but cannot delete an entry from a different list. please see below for more details.

I can see the workflow is still running.

enter image description here

Improve this question

1 Answer 1

Reset to default
1

You really should use the ID of the item - then you're eliminating the risk of string matching. Change the field in the lookup to ID and change the return field of the lookup to ID as well. Then you should be fine (provided the user does in fact have rights to delete the item, if thats not the case you need to place the delete part in an app step).

enter image description here

Improve this answer
8
  • ID is different for different list know ?. I have tried it with PartID as a test which gives the result as well.
    – Rinu
    Commented Feb 19, 2018 at 7:16
  • I don't think I understand your question?
    – Morten K
    Commented Feb 19, 2018 at 7:19
  • StockID_PurchaseDate is a calculated column in the StockItems list and the same field is added as a lookup field to the "Printers Consumable Requests" list where the workflow runs. I doubt if there is string mismatch. i even checked with different fields and permissions.
    – Rinu
    Commented Feb 19, 2018 at 7:33
  • If you use a lookup already there absolutely no reason not to match by id rather than a string. Like I said change the field to be ID when you're deleting. And when setting the value take the id (As opposed to the text) from the lookup field on the item and your all set.
    – Morten K
    Commented Feb 19, 2018 at 7:39
  • Just one questions though - are you trying to delete multiple items within the same list here? if that's the case you need to add a loop to iterate through all the matching items.
    – Morten K
    Commented Feb 19, 2018 at 7:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.