Microsoft Flow weekly remainder

Question

I want to create a flow that checks which files have been added without being filled with the appropriate Metadata.

The flow checks that and then sends an email once a week to the creater letting them know that these files have no Metadata

Can anyone help me achieve this result

Zdeněk Vinduška · Accepted Answer · 2019-08-01 12:50:52Z

1

here is short version:

Create Flow with Recurrence
Get Files from Library (if there will be more libraries, there should be more these functions. I selected my test site and default Documents library. I also filtered documents only for new (created 7 days ago and newer) You can change this.
- Created gt '@{getPastTime(7, 'Day', 'o' )}'
Add foreach loop - In foreach loop will be Condition (IF) for your selected METADATA which should NOT be EMPTY and into TRUE statement will be SEND email to Created email (everything on screenshots)
I tested with empty Title on new Document (only this document was get with Flow, because my filter)

Done in 15 minutes.

Hope it helps!

answered Aug 1, 2019 at 12:50

Zdeněk Vinduška

2,8892 gold badges12 silver badges24 bronze badges

thanks a lot. I marked it as solved. What would happen if more than one file was missing the metadata ? Will the email consist of mutiple links then ?
– Ed1995
Commented Aug 1, 2019 at 14:34
Yes it will get all files with missing metadata. No, email is per one document. If you want multiple links per Author, it will be a little difficult. But this is the base scenario. You can alse change first filter to your columns eq '' and it return all files with empty metadata values directly and no IF will be needed.
– Zdeněk Vinduška
Commented Aug 2, 2019 at 6:29
how would I go if I would want mutiple links per author. Can you help me with that ?
– Ed1995
Commented Aug 2, 2019 at 6:39

Add a comment |

1 Answer 1