Power Platform Community Forum Thread Details

I have the following flow which i need some assistance with.

I am pulling Employee Holiday data from a SQL View (which is joining 3 tables to give me the relevant date) i cant use the SQL Trigger for new item or update item as this doesnt work via On-Premise Gateway.

So currently the flow runs every hour Recurring Trigger, and picks up any new entries and populates these into a Sharepoint list... Sharepoint list has a column called sqlid & adsence_id is the primary key in the sql table.

My issue is, if a holiday request is deleted, or amended this creates a new absence_id, so i want to be able to delete the old absence_id which will no longer show in the SQL View, but is present in the Sharepoint Table...

Any advice much appreciated for best approach.