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

%3CLINGO-SUB%20id%3D%22lingo-sub-2019566%22%20slang%3D%22en-US%22%3ECreate%20a%20list%20of%20users%20who%20did%20not%20complete%20Power%20Apps%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019566%22%20slang%3D%22en-US%22%3E%3CP%3ENeeding%20help%20in%20creating%20a%20flow%20to%20create%20a%20list%20of%20users%20(filtered%20by%20manager)%20who%20did%20not%20complete%20a%20Power%20Apps%20form.%26nbsp%3B%20I%20am%20referencing%20a%20SharePoint%20list%20in%20which%20the%20Power%20App%20is%20built%20upon%2C%20however%2C%20drawing%20a%20blank%20as%20to%20how%20to%20generate%20a%20list%20of%20users%20who%20have%20not%20completed%20the%20form%20(Daily%20Health%20Check).%3C%2FP%3E%3CP%3EThis%20is%20what%20I%20have%20right%20now.%26nbsp%3B%20Don't%20know%20if%20I%20am%20on%20the%20right%20track%20or%20not.%26nbsp%3B%20Any%20help%20is%20greatly%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-12-28%2023_02_09-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%E2%80%8B%20Edge%20Beta.png%22%20style%3D%22width%3A%20563px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243296i6ED40CA3FDB9ADBE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222020-12-28%2023_02_09-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%E2%80%8B%20Edge%20Beta.png%22%20alt%3D%222020-12-28%2023_02_09-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%20Edge%20Beta.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-12-28%2023_03_17-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%E2%80%8B%20Edge%20Beta.png%22%20style%3D%22width%3A%20521px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F243294i6AFACFB61F0DE911%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222020-12-28%2023_03_17-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%E2%80%8B%20Edge%20Beta.png%22%20alt%3D%222020-12-28%2023_03_17-Edit%20your%20flow%20_%20Power%20Automate%20and%203%20more%20pages%20-%20Work%20-%20Microsoft%20Edge%20Beta.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2019566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044364%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20list%20of%20users%20who%20did%20not%20complete%20Power%20Apps%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044364%22%20slang%3D%22en-US%22%3E%3CP%3ELatest%20update%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20now%2C%20the%20only%20work%20around%20I%20have%20found%20to%20filter%20all%20users%20by%20assigned%20manager%20to%20capture%20all%20users%20who%20have%20not%20submitted%20a%20PowerApp%20form%20would%20be%20using%20filter%20array%20with%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%40or(equals(item()%3F%5B'Mail'%5D%2C%20'useremail')%2Cequals(item()%3F%5B'Mail'%5D%2C%20'useremail'))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20currently%20added%20to%20the%20%3CSTRONG%3EFilter%20Array%20-%20Direct%20Reports%3C%2FSTRONG%3E%20step%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20filter%20by%20manager%20automatically%2C%20without%20having%20to%20manually%20update%20this%20step%3F%20We%20may%20have%20to%20update%20this%20frequently%20if%20there%20are%20a%20lot%20of%20staff%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ManagerReport.png%22%20style%3D%22width%3A%20194px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244945iD367320DF37587C5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ManagerReport.png%22%20alt%3D%22ManagerReport.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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