Flow to send reminder to email

[ratanapouy]

Hi,

I have sharepoint list which contain "Remaining" column. i want to create a new flow; if Remaining column below 3-day; it will automatically send email to Responsible Person by line item.

Thanks,

Ratana

[v-yamao-msft]

Hi ratanapouy,

What’s the column type of Remaining? I assume that it should be a Number column.

You could consider to add a condition in your flow. If the value of the Remaining column is less than 3, send an email.

According to your description, I create a list which has a Number column and Person column. Then I create a flow likes below.

The flow will run every minute and if the value in the Number column is less than 3, an email will be sent to the responsible person.

For your scenario, you could consider to change the Frequency to Day.

This doc about adding a condition to a flow for your reference:
https://flow.microsoft.com/en-us/documentation/add-a-condition/

Please try it on your side to see if it will work for you.

Best regards,
Mabel Mao

[ratanapouy]

"Remaining" column is calculated column, it doesn't show "is less than" in condition.

[v-yamao-msft · Accepted solution]

Hi ratanapouy,

Thanks for updating.

According to your description, I change the “Remaining” column on my side to a Calculated column, as you said that when using the calculated column in the condition, there is no “less than” can be selected.

Please consider to use workflow definition language int to convert the parameter to an integer.

Add a Compose action, set its function as”@int(Remaining)”.

PS: When the first time you save the flow, you will get an error message. Just replace the dynamic content “Remaining” with the highlighted part, then save it again, the flow will be saved without error message.

Finally, the flow would be configured something likes below. It works fine on my side. Please try it on your side and post back if it works for you.

Best regards,
Mabel Mao

[emiller7695]

Hi Mabel,

I have created a similar flow for reminder emails. I have a calculated column for Days Remaining until a due date, and I have included the condition that the email will be sent when the Days Remaining column equals 0. Do you have any idea why the flow would work for some of the entries in the SharePoint list but not all? When I run it, 4 emails should be sent today, but only 2 are being sent.

Thanks:)

[jreden]

I am interested in sending a reminder email at intervals when a task is not completed.  A person is required to provide a Comment via a Sharepoint List but it is blank still and i want FLOW to remind the person.  Do you know i can add that step?  I would want to add this step to everey person that needs to comment.

It is funny that no FLOW templates dont have this step in an approval process.

Thanks!!!!