Send an email if an excel file has been modified

(0) Share

Report

Posted on by Edvhdy

101

Hello,

I'm trying to create a flow that informs users if an excel file is present in a sharepoint library
has been modify.

If the file has been modified an email is sent at 7 a.m. otherwise nothing is sent

At first I wanted to start with a sharepoint trigger but I'm stuck with the timeout.

How to set up a library scan every day at 7 a.m. and if the file has been modified
an email is sent?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Edvhdy you can use two flows, one to capture the modify propertie and save that into a sharepoint list. A second flow schedule that runs in the time you need and read the sharepoint list that contents your data about files modified and filanny notify by email 🙂

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report

hi @ChristianAbata ,

I thought of making your solution,
I did create my first flow https://ibb.co/5sVwqts , but I don't know how to make the second flow, how do I compare?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Edvhdy please follow this example

Was this reply helpful? Yes No
Verified answer

Edvhdy 101 on at

Like (0)

Report

I think I succeeded,
This is how I did it:
1st flow:
When a file is created or modified (properties only)
Get files (properties only)
Apply to each - value - Create item in list A

2nd Flow:
Recurrence
Get items
Condition - empty (body ('Get_items')? ['Value']) is equal to false
yes - send email and delete items to make the list A empty

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

excellent @Edvhdy please mark as solution the parts you consider could help to other users 😉

Was this reply helpful? Yes No
Edvhdy 101 on at

Like (0)

Report

@ChristianAbata Thank you for your precious help !

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Edvhdy you are welcome friend

Was this reply helpful? Yes No