cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Send email to desired person based on certain sharepoint list column

Hi All,

I am working on an app where I am collecting data from multiple users in a SharePoint list using an app, now this app indicates the users that the value in certain form is equal or less than the desired value. What I want is that if the value is less than the desired value (Desired value also given in SharePoint list column) it should automatically send reminder email to the relevant user (I have also 2 columns: 1 where the relevent person email id is given and 2nd where CC email id's are given.

 

KR
Zuhair

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hello Team,

 

Here is what you do. You insert a condition, (in my case the desired value is in column named Status Value) wherein if the status value is less than 2 (here 2 is my bench mark you can choose your own), then it should give out a true status and the logic moves to left part of condition.

 

 

yashkamdar_0-1603133644350.png

 

Here you can just use an Send an email action and populate the send an email action based on the values from your list columns.

 

yashkamdar_1-1603133876591.png

 

Ofcourse I am only showing the To and the CC part here but you will need to fill out the subject, body too.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2
Super User II
Super User II

Hello Team,

 

Here is what you do. You insert a condition, (in my case the desired value is in column named Status Value) wherein if the status value is less than 2 (here 2 is my bench mark you can choose your own), then it should give out a true status and the logic moves to left part of condition.

 

 

yashkamdar_0-1603133644350.png

 

Here you can just use an Send an email action and populate the send an email action based on the values from your list columns.

 

yashkamdar_1-1603133876591.png

 

Ofcourse I am only showing the To and the CC part here but you will need to fill out the subject, body too.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Thanks a lot for the swift response, a quick one, is it possible if I want to keep sending email reminders every 5 hours until condition met?

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,025)