Delete Item From Sharepoint List - ID Number Lookup

[Anonymous]

Hi,

I am trying to use power automate to delete a specific item (ID) from a list of items that contains a specific number in the items title column. Since the item ID number is different than the item title number I would like to use something similar to a vlookup where it outputs the ID number of the item that matches the item's title number.

Context: Submitting a form response with Microsoft Forms triggers powerautomate to create a new item in sharepoint with the title name (number) of the low charge battery. After that is done Powerautomate deletes the item (ID #) that contains the title of the battery that is fully charged.

Do I need to create an expression?

Here is a screenshot

Thanks,

Jeromy

[ekarim2020 · Accepted solution]

Your Get items would look something like this to get the record:

Note the use of single quotes to surround the 'Fully Charged' form field.

Bear in mind that your Title field should be unique or you may end up with duplicate records.

Get Items action will return an array - even if it matches only one record. The ID number for the Delete action will come from the Get Items action.

However, I didn't understand the flow, as it sounds as if after Create an Item action in a SharePoint list, the item in then deleted? There may be an easier way to achieve your desired outcome if you could describe the flow process in a little more detail.

Ellis

[Anonymous]

Thank you! This is working so far.