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

Brass Contributor

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!

 

2020-12-28 23_02_09-Edit your flow _ Power Automate and 3 more pages - Work - Microsoft​ Edge Beta.png

2020-12-28 23_03_17-Edit your flow _ Power Automate and 3 more pages - Work - Microsoft​ Edge Beta.png

1 Reply

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.

 

ManagerReport.png