Flow 'Delete item' Action Issue

[Phineas]

Below is the last piece of a flow I am trying to finish.

I am trying to compare the 'Person Number' column of and Excel workbook to the
'Title' column of an SP List, and where the item does not exist in the Excel document
it is to be deleted from the SP List.

When I formatted as shown in the first image I am getting an 'item not found' error,
even though the item does exist on the SP List.

When I format using the 'ID' (as shown below), rather than the 'Current item', the flow deletes everything. What am I
doing wrong? The goal of the 'Delete item' action is to ONLY delete items from the SP List that are not in the Excel
workbook.

[creativeopinion]

I just posted what your flow should look like in a different thread. Please refer to this post and let me know if this helps to clarify things. 

You are referencing the ID from your Get Items action to delete and not the ID of the items you've filtered on which is why this isn't working the way you are expecting it to work. 

[Phineas]

How do this look? Do I have it right this time?

[creativeopinion]

The Create SP branch is incorrect. 

The way the Apply to Each action is set is incorrect. 

With the way you currently have it set up you are:

• Looping though the filtered Excel items that need to be created. Let's say you returned 10 items from your Excel sheet...this action would loop through 10 times.
  •  Looping though the values of the returned items from the Get Items action and creating an item for each of those items returned. This would only loop through the number of times to match the number of items returned from the Filter Array action. If the Filter Array returned 20 items but you need to create 40 items... It will only create 20 items. 

You need to use a expression to get the dynamic content. Pls refer to my previous post. 

[Phineas]

I apologize for being a little slow, it is not intentional, I beg patience.

I have attempted to replicate your flow as instructed, and I keep running into issues.

Here is the latest, based on your post. Please clarify where I've missed the mark in structure.

Also, the Excel and SharePoint currently have the exact same 597 items, with matching 'UniqueID's - In Excel its the 'Person Number' column and in SP its the 'Title' colum. 

[creativeopinion]

Filter Array - SP Items to be Deleted
From the screenshots you've sent, it doesn't look like this Filter Array is working correctly. 

There must be an error in the way the Filter Array is set up. If there are 597 items in your Excel sheet and 597 items in your SharePoint list both with the same ID's, the Filter array should be empty. This would indicate that no items need to be deleted. I believe there is an error with the values you are comparing. Please hover over each output in the filter array action and take a screenshot of what each output is referring to. It would help to troubleshoot.

Filter Array – Excel Items to Create in SP

It looks like this Filter Array is working correctly. Because you've indicated that the Excel Items and SP Items match right now—there shouldn't be any items that need to be created. To confirm this, you should add an extra item in your Excel sheet. If this Filter Array is working correctly, it should indicate that there is 1 item that needs to be created.

[Phineas]

Edit of original -

I fiddled around with it and finally got it to '0' in the delete output. I ran a full test, nothing was deleted.

I, also, added an additional item to the source data (Excel) and ran the flow. The 'Create action' did see the new item, however the item was not created in the SP List.

[creativeopinion]

The Apply to Each action must be run on the items returned from the Filter Array. You currently have the Apply to Each action running on the values returned from the List Rows Present in a Table action which is incorrect.

The purpose of the Filter Array action is to filter out the items in Excel that you want to Create in SharePoint. In this case, you have a single item returned.

You will need to use an expression to access content from the Filter Array action. The content will not be available to select through the list of dynamic content.

Type in a question mark, square brackets and single quotes. The text that goes between the single quotes is the text in red from the Filter Array output. 

Place your cursor BEFORE the ? mark and insert the Current Item dynamic content.

You will need to repeat this step for each piece of content. For example, it may look like this:

items('Apply_to_each_-_Excel_Item_to_Create_in_SP')?['Asset ID']

To clarify, you will need an expression for each field of content you want added to SharePoint in the Create Item action. The text in between the single quotes will match the RED text from the Filter Array output which is essentially the column names from your Excel sheet.

The purpose of this is to map the Excel column to the appropriate SharePoint column.

[Phineas]

Are these the proper corrections -

[creativeopinion]

It looks correct. Were you able to successfully Create the SP item with your flow?

[Phineas]

No, the new item was not created.

In the 'Create item' action, all of the expressions look like the
example shown in the 'Title'.

[creativeopinion]

Was there an error? 

Can you try to remove the Create Item action for now and just use a Compose action with the same expression for the Person Number (that you indicated you used in your screenshot) to see if the Compose action returns the Person Number?

[Phineas]

Changes made. Flow still stops at 'Apply to each'.

[creativeopinion]

Can you try another field? [' First Name'] or ['Last Name']

[Phineas]

I've almost got it all working.

The Filter array and Compose have accurately identified the one item that needs to
be deleted.

The 'Delete action' is hanging at the Apply to each.

[creativeopinion]

In your Apply to Each action, you are referencing the wrong output. Currently, you are referencing the Compose action output from above the Apply to Each action. That compose action is being used to return the number of items from your Filter Array action. 

In your Apply to Each action, you need to reference the body output from the Filter Array action.

[Phineas]

Made 'Body' Apply to each output, same result -

No delete occurred.

[creativeopinion]

You need to access the SP ID property from the Filter Array action with an expression.

Start by typing ?['ID'] then place your cursor at the start of the expression and insert the current item. 

You can also insert the expression into a Compose action if you'd like to verify the output of it. The expression should return the SP ID. You need that ID for the Delete Item action. 

[Phineas]

I typed it just as you illustrated (see 'Delete item' note).

Clicked on 'Current item', PA changed it to item.

The results were the same - No Delete occurred.

[creativeopinion]

Your expression is incorrect, you are referencing the ['Title']. You need the SharePoint ID. Your expression should use ['ID'], not ['Title'].