I am utilizing Jamie McAllister MVP steps for Updating Excel Values to SP list with Flow. Following is the video link. This is what I was needing for a solution on SP Online away from a SP 2013 On prem Access data base run update to SP list. My question is what condition can I add to this existing Flow to make it remove rows in SP when an item has been completely removed from the Excel sheet. Example: Title Test8 row deleted in excel sheet and when flow runs in SP list the Title Test8 row will also be removed. Currently if I remove it row in excel sheet and run the flow in SP list it remains but is blank for the whole row (including title). Appreciate the insight and assist.
UPDATE: I have been able to make a secondary Flow that will delete a row based on a category being null. What I have as my secondary Flow is Recurrence, SP Get items, Apply to Each SP Value, Condition SP category = null, If yes, SP delete item SP ID, and for no I have nothing. Now I’m trying to figure out is how do I take this piece of the separate flow and put it at the end of the Flow I mentioned above.
