Forum Discussion

ChapmanBryan's avatar
ChapmanBryan
Brass Contributor
Dec 29, 2020

Create a list of users who did not complete Power Apps form

Needing help in creating a flow to create a list of users (filtered by manager) who did not complete a Power Apps form.  I am referencing a SharePoint list in which the Power App is built upon, however, drawing a blank as to how to generate a list of users who have not completed the form (Daily Health Check).

This is what I have right now.  Don't know if I am on the right track or not.  Any help is greatly appreciated!

 

  • ChapmanBryan's avatar
    ChapmanBryan
    Brass Contributor

    Latest update:

     

    Right now, the only work around I have found to filter all users by assigned manager to capture all users who have not submitted a PowerApp form would be using filter array with the following:

     

    @or(equals(item()?['Mail'], 'useremail'),equals(item()?['Mail'], 'useremail'))

     

    This is currently added to the Filter Array - Direct Reports step

     

    Is there any way to filter by manager automatically, without having to manually update this step? We may have to update this frequently if there are a lot of staff changes.

     

Resources