web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / how to I schedule a po...
Power Apps
Unanswered

how to I schedule a power automate scheduled flow based on value provided from Powerapp ?

(0) ShareShare
ReportReport
Posted on by 90

Hey , I have a  dataverse table PromotionProcessStages   with Columns Stage(Text) , StartDate, ReminderDate, EndDate (all 3  columns of type datetime)

Nida_Sayedi_0-1714979127912.png

 

I have another dataverse table DBSendreminder where iam defining  a single value for  how many days email reminder notification  need to be send to particular user in NoOfdays Column

 

The NoOfDays value can be 3 or 4 or 5 anything 

Nida_Sayedi_1-1714979312120.png

 

I want a flow that checks StartDate for each Stage and send email , example if NoOfDays is set as 5 it should send mail any 5 days before  the ReminderDate for that particlular Stage . If NoOfDays is set as 3 it should send mail on  3 days before the ReminderDate for that particlular Stage. It should be dynamic flow . if the reminder Date is today's date also it should satisfy.

 

 

How do I achieve this , What condition should I write in the flow so it sends mail that many number of times specified in powerapp.

 

 

For Example For Stage 02. Define Affordability and Eligibility Matrix if Start Date is 05/02/2024  (2nd May) and ReminderDate is 05/15/2024(15th May) then flow show send reminder email on any 5 days before or on 15th May 2024 ( 5 days can be daily 1 email for 5 continuos days or alternate days etc)

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 494

#2
WarrenBelz Profile Picture

WarrenBelz 352 Most Valuable Professional

#3
11manish Profile Picture

11manish 323

Last 30 days Overall leaderboard