web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Flow to find entry

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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?

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard