Notification when a file is not uploaded by particular date OneDrive

[PM11]

Hi, 
I would like to create a flow task that sends a notification to a user who hasn't uploaded files till a particular date. The flow task has to notify the user that he has several days till the deadline. 

For example, the user has to upload files to a folder in OneDrive by 5th of each month. If no files are uploaded by 5th, a notification to be emailed to the user reminding him to upload files by latest on 10th of the month. If no files are uploaded by 10th, a second notification to be emailed. 

Any ideas will be appreciated. 

[ChristianAbata]

hi @PM11  my friend I recomend to you to define a sharepoint list with and a sharepoint group.

Then you can use PA to capture when the user upload a file and save it in a sharepoint list column so then you can run a schedule flow to see in your list what is the user that don't have the column mark as file uploades.

	Upload file
User 1	Yes
User 2

So as you see if you read your list and the value is empty then you can send an email 

[v-litu-msft · Accepted solution]

Hi @PM11,

Do these uploaded file names contain the name of the uploader? Such as user1Name.text?

If you are using OneDrive, as far as I know, there is no way to know who submit the file into the OneDrive folder, so if you could add the user name (or other unique code) into the filename, the problem will be much easier.

You could create a SharePoint list or Excel table to store these user name or ID who needs to upload the file, then create a column named "upload" and its value is "Yes" or "No". Every 5th of a month, list all files of the special folder that stored in these uploaded files, then compare these filenames with the SharePoint list, if the filename contains one item of the list, check it, set its "upload" value to "Yes", after a loop, if still not find the name, leave it empty or set it to "No".

After the loop, check the list items, find which "upload" is "No" or empty, send the email to the corresponding email. 5 days later, do the same thing above. So you should create two recurrence flow run on the 5th and 10th of a month.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.