Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
Expand all | Collapse all

Filtering list

Jump to Best Answer
  • 1.  Filtering list

    Top Contributor
    Posted Mar 03, 2021 06:03 AM

    I am trying to create a list of Birthdays for the current month. I have a master list of Employees in specific departments in Sharepopint.
    My Flow creates an Array where the birthday month is the current month and then creates a table, which is emailed out.
    My problem is that I need to Filter the array again on a second field - Status - so we only see current employees.
    I tried to add a second "Filter Array step, but the Field I need to check is unavailable - I looked in the first Filter Array step and it is not available there either.
    Any ideas how I can add that to the mix?



    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------


  • 2.  RE: Filtering list
    Best Answer

    Posted Mar 04, 2021 02:11 AM
    Hi Brian

    Have you tried applying a filter in your  SharePoint action, "Get Birthday List"?

    This way you don't have to filter in the subsequent actions



    ------------------------------
    Nabeel Salie
    SharePoint Developer
    ------------------------------



  • 3.  RE: Filtering list

    Top Contributor
    Posted Mar 04, 2021 06:37 AM
    This worked great - i had a condition in there but after a little trial and error I got both to work. Thanks!

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------



  • 4.  RE: Filtering list

    Posted Mar 04, 2021 03:06 AM
    What about putting the filter about current employees on the get list items action?

    ------------------------------
    Rebecca
    ------------------------------