Need to send an email nofitication on revision date to the responsible of a folder

[Jim91]

Hello,

I have a couple of folders with a revision date and a responsible for this folder.

I want the responsible to receive a reminder when the revision date comes.

I can't figure out how to do it, do you any idea?

I'm able to send myself a reminder, but I would like to send it to the responsible instead.

Otherwise my second idea is to make an outlook rule to transfer it to the reponsible after I receive it.

[Sundeep_Malik · Accepted solution]

Hey @Jim91 

You can use an action called Get Files(Properties Only).

By this you will be able to get information of each column.

After this just use a compose and store the revision date in it. This will automatically create a apply to each loop.

Next use a condition to compare it with revision date.

If the revision date matches to the today's date,

in the if yes send a reminder to the person.

To fetch the person's email:

Use this type of syntax:

items('Apply_to_each')?['Responsable/Email']

You can make this flow scheduled and run it every 24 hours.

In the date compare the format with similar to in SP List.

I hope this helps.

[Jim91]

Thank you, it seem to work until I do the e-mail part where I have this message when I try to save:

Seems like I need to add something at the end of the code?

[Jim91]

[Sundeep_Malik]

@Jim91 

Can you add the screenshot of your flow in edit mode? Though not sure if I will understand your language or not. hehe. 😉

[Jim91]

Yes! 

Here it is:

My error was the person's email but now it works great except it tells me there's an error when I test it but it sent all the emails needed. Here is the message I had at the end of the test:

[Sundeep_Malik]

@Jim91 

In the condition write:

formatDateTime(utcNow(),'dd/MM/yyyy')

[Jim91]

Hello, 

When I try with this in the condition it does an error at the very start.

It's weird because it seems like it's the exact same error, but with only utcNow() it works and then it crash!

[Sundeep_Malik]

@Jim91 

I everytime make this mistake. I think its not going ahead because sometimes date can be empty.

Can you add another row after the condition and in the condition write this:

and compare date to null or blank.

[Sundeep_Malik]

@Jim91 

or if the above also does not work.

Just add this instead of formatdatetime function:

utcNow('dd/MM/yyyy')

[Jim91]

Thanks a lot it works perfectly now!

Here is what I changed: