cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roberto_el_Hajj
Super User
Super User

Filter on date and time from dataverse using power automate

Hello,

 
Hope you're doing well!
 
My problem:
I have a "Reminder date" field in dataverse, it's entered by the user.
 
I would like to send a reminder to the user by checking everyday if any row has in its "Reminder date" column to day's date and time.
 
for example :
The user entered a row on 11/12/2021.
The reminder date  entered is 11/13/2021.
The flow should check everyday if any row got the date of today in the " Reminder date " and if yes he should send a reminder to the user.
 
So how can make the flow send a reminder depending on today's date and the date/time entered by the user ?
 
Roberto_el_Hajj_0-1636716288661.png

 

 

What's the best practice function to use to achieve the above result?
 
Any help will be highly appreciated.
 
Thank you!
1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Roberto_el_Hajj ,

 

You could create a scheduled flow.

vxiaochenmsft_1-1636941499095.png

vxiaochenmsft_2-1636941518098.png

 

vxiaochenmsft_0-1636941473626.png

vxiaochenmsft_3-1636941886074.png

formatDateTime(item().crba2_reminderdate,'MM-dd-yyyy')
formatDateTime(utcNow(),'MM-dd-yyyy')
 
Best Regards,
Wearsky

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @Roberto_el_Hajj ,

 

You could create a scheduled flow.

vxiaochenmsft_1-1636941499095.png

vxiaochenmsft_2-1636941518098.png

 

vxiaochenmsft_0-1636941473626.png

vxiaochenmsft_3-1636941886074.png

formatDateTime(item().crba2_reminderdate,'MM-dd-yyyy')
formatDateTime(utcNow(),'MM-dd-yyyy')
 
Best Regards,
Wearsky

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,670)