Hi,
There is no trigger to trigger a flow when excel row is deleted. So workaround would be to create a scheduled flow which runs every specified interval, checks the items in sharepoint list and then check whether same item exists in excel or not, if not > delete that item from SP list.
Also we need a unique id column that can acts as unique identifier for sp list and excel data so that data can be easily looked up.
For demo purposes- i have created a sp list having 2 columns - Title and Office where title column is unique identifier.
Now same data is found in an excel file enclosed in table
Now let's see how flow can be designed.
So a scheduled flow has to be created which should run in specific interval of time.
Following steps need to be followed under scheduled flow
1. Get items from the sharepoint list. enable pagination if needed.
2. Now loop through each item in get items action output and do the following steps
Follow the steps to be done when inside the loop
2.1- use list rows in table action and use a filter query to filter only the rows whose title equal to title of current iterating item details as shown below
2.2- use a condition to check whether the number of items/rows returned by list rows in table action is zero or not. if zero- it means row in the excel is deleted and thus need to be deleted from excel as well. see below for the code
Expression -
length(outputs('List_rows_present_in_a_table')?['body/value'])
In yes branch - use delete item action to delete that sp list item
Hope this helps !
