Hi there,
I currently have two lists, one called payroll guide which has a list of when payroll months begin and end (a column for payroll month, payroll begin date, and one for payroll end)
The other list is just one entry - the current payroll month at that time
I want to set up a flow which tags the entry on the main payroll guide as 'previous payroll', by finding the entry on the main payroll guide that has the 'payroll end' that is 1 day less than the 'payroll begin' date on the 'current payroll' list., for example if the current payroll begin date is 23/09/2019, i want to find the entry in the payroll guide list that has a 'payroll end date' that is on the 22/09/2019.
So far I've got two flow entries which 'get' the lists, but how do i then go about filtering the main payroll list based on the criteria i mention above?

Report
All responses (
Answers (