Compare users at Scheduler workflow - power automate

(0) Share

Report

Posted on by KrishR

431

Hello Power users,

I'm a basic user in Power automate.

I'm building a scheduled site ms flow on Sharepoint site. I would like to run this site scheduled workflow once in every week. It should run on a Sharepoint list in which the group of people submit their weekly status reports. Scheduler workflow will look through the list and find out the users who haven't submitted a record for that week and send an email notification. There is a specific date (Let's say every Friday) in that week people should submit on or before that. If they didn't do it by that date in a week should be notified.

I would like to build this workflow in such a way, flow should look through the group (list of people submit to that list) and compare with who hasn't submitted and notify them.

Any suggestions please?

Thank you so much in advance!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Mister_Shaik 1,008 on at

Like (1)

Report
Copy link

Link copied!
Hi @KrishR ,

You can build a flow with Scheduled desktop flow and set it to trigger on specific dates, after the trigger you can use the below actions to achieve your need,

Get the items that were created starting this week till now,
Using Select action, collect all the users emails, who have submitted their weekly reports
Assuming that you're going to get and store all users who are suppose to submit the reports, into an array variable, you can use a ApplyToEach with an if condition to check who didn't submit the report and send an email alert to them

The filter query with expression to get start of current week is below,

Created ge '@{addDays(utcNow(), sub(0,dayOfWeek(utcNow())))}'

Hope this helps 🙂

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mister_Shaik ,

Thank you so much for your time in explaining in detail. Hope this is will work.
Thanks again 🙂

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

@Mister_Shaik ,
Thank you so much once again for your help. I tried some tests with your ideas and worked fine. I was little confused at the point 3. Do I need to save all my submitters to an email ( which is groupEmails variable in the image you provided) and compare with current item? Can you help me please?

Thank you.
Krish

Was this reply helpful? Yes No
Mister_Shaik 1,008 on at

Like (0)

Report
Copy link

Link copied!

Hi @KrishR ,

Yes, you need to have a array variable which holds all your group member's emails (groupEmails).

Then you just need to loop each group member inside the variable and add an if condition to check if the member is inside the submitted members array (from the select action), if no, then send out the emails to notify or any other actions.

Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mister_Shaik ,

Thanks for your help but I'm stuck at something, can you please help? Action 1: I did get few items based on a condition (filtered). Action 2: And did get user details (emails) from Sharepoint group. I went to apply to each action and not sure what would be the inputs. I would like to compare Action 1 and Action 2 and append the values (emails) to a string/array. Can you please help?

I was really running into confusions on what to compare with what and what should I use array/string at some locations?

Thanks in advance!

Was this reply helpful? Yes No