Hi @Roko06 !
I have tried something. I hope this is what you need.
Below pic is my flow:
Condition expression is:
length(outputs('List_rows_present_in_a_table')?['body/value'])
Let's say I have this data in my list:
And in my excel:
3 cases I have taken care here:
(1) In case if excel table data is empty.
(2) Used a try and catch block strategy here. The try part will update the row corresponding to a key column - key value pair. Here in my list, Job ID is unique hence it should not change. So try to use a column whose values should not be changed.
(3) And finally the catch part will add the new list item in the Excel worksheet, if an item has been added in SharePoint list.
In order to implement the try - catch block strategy, click "Configure run after" on the catch part, and then check "has failed" box.
Outputs:
Case 1:
Before...
After...
Case 2:
Before...
After...
Case 3:
Before...
After...
So this workflow ensures that no duplicates are added to the excel worksheet as it rewrites that data here.
Hope this helps.
Regards,
Nathan Alvares
----------------------------------------------------------------------------------------------------------------------------------------
If this helps & solves your problem, please remember to give a "Thumbs up" and "Accept my solution" as it will help others in the future.
