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

1 Answer 1


here is short version:

  1. Create Flow with Recurrence enter image description here
  2. 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' )}' enter image description here
  3. 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) enter image description here
  4. I tested with empty Title on new Document (only this document was get with Flow, because my filter) enter image description here enter image description here

Done in 15 minutes.

Hope it helps!

  • 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. 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.