Email Reminder to users who haven't submitted data to a SharePoint list

(0) Share

Report

Posted on by CRam3b92

Hi,

I have an app that employees can submit their working time which posts their data to a SharePoint list.

I am looking to build a flow that will send an email reminder to users who have forgotten to submit data for each week. Not really sure how this should look.

In my head I am thinking this should work by checking the user submissions to the SharePoint list against a group of users and if it can identify the users that have not submitted for the current week and sends them an email reminder to submit their data.

Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI,

If the time sheet has a name column, then could take retrieve the complete list every week, sort it by those lines with a zero hours then send an email to those who have not submitted their time. I am no expert in how you would achieve this.

Regards,

Andrew

Was this reply helpful? Yes No
Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @CRam3b92 ,

You can refer to below example:
1. recurrence trigger
You can select your own time zone here.

2.Initialize variable: create a list include all the user's email addresses.

3. Get items action: to get all the items created since last Monday and please also remember to add an apply to each action in advance and its from value is the array variable we created before.

Filter query formula:
Author/EMail eq '@{item()}' and Created gt '@{addDays(addHours(utcNow(),-15),-6)} '

//for the second condition, I just use example that for each Sunday 3 pm, flow will check all of the items created from Monday to Sunday's 3 pm and if someone does not created item inside list, flow will be able to find out and send the email notification. You can change the "-15" according to your own idea.

4. Condition:
Formula: length(outputs('Get_items')?['body/value'])

5. Send an email:
TO: Item()

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
CRam3b92 34 on at

Like (1)

Report
Copy link

Link copied!

Hi Hen,

Thanks for this response. I'm just wondering in terms of building the list of emails - can this be done using a SharePoint list? As I have a SharePoint list that includes all these email addresses?

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @CRam3b92 ,

Yes, of course you can. Then the variable's value could be replaced by another get items action to get all the email addresses value.

Best Regards,
Hen Wang

Was this reply helpful? Yes No