Hi @MuhammadNiyas
looking at the current flow, it would work but the problem would be as you said, if flow have 20 resumes approves yesterday and add those 20 records to onboarding excel, then it should not consider those 20 records when running today.
So for that , one resolution would be to add one more condition before adding row to onboarding excel,
I am assuming that there is a column in recruitment excel table which will be unique ID for each row where each row stands for the each employee detail.
Currently i assume the recruitment excel table looks like below 🙂
So here i assume ID column is a unique id for each row
So here is onboarding excel table looks like:
So based on above, i would suggest to add a condition before adding the row to onboarding table 🙂
something like below under Yes branch as per your flow 🙂
expression used :
length(outputs('List_rows_present_in_a_table_2')?['body/value'])
So overall logic of this flow would be it would be iterating through each row of recruitment table and checks if Status column of each row equals Resume Approved, if it is true, then it goes to Yes branch and then it checks if the same ID column value of each row of recruitment table is already present in onboarding table as well, That is done via using filter query as you see the above flow screenshot.
Then it uses condition to check if the output of list rows of onboarding table is zero , if it is zero, it implies that no such row of that employee has been added to onboarding table so flow should add the employee details to onboarding table, else not 🙂
Thus this way flow can be modified 🙂
