You’re offline. This is a read only version of the page.
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?
Hi @Anonymous ,
i understood, that you need infos about how to build the filter queries.
Please follow this link. There ist a solution for nearly every filter requirement:
https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/
If this post helps you, please mark it as solution.
Best regards
Stefan
Share
Report
All responses (
Answers (
497
