Hi @nitsharma
You can create a flow which checks for all the items that exist in SharePoint list but not in excel.
Flow Details
Trigger -> Manual Trigger
Action -
1. Get all items from SP List
2. Get all items from Excel
3. Initialize a variable of type array.
4. Apply to Each loop on SP list
5) Inside Apply to Each loop, add a filter array action of Excel sheet and map columns between SP and Excel.
6) Add a condition on length returned from the filter array action. If the length is one, that means the record exists in both. If the length is 0, that means item exist in SP list and not excel.
Condition: length(FilterArray) = 0
If true: Append the item to Initialized array variable
If false: Do nothing
7) You can print out the array in the end or create new items if needed. This will be the resultant array of all the missing items
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
