Announcements
I have a SP online list with a formular column [NOW] - [Due Date] and I can easily filter out any records <30 days. However, we would like to email those filtered records @09:00 daily to some users
How can we do this via Flow / Power App ??
Thanks
Hi @YEUNG_Gabriel,
If you would like to schedule a flow, then this is better to be done under Microsoft Flow.
Run flows on a schedule
You may take the following thread as a reference:
Flow to email sharepoint list
Follow my steps in the thread above to configure the Flow.
If you have any further questions, please post back.
Regards,
Michael
Hi
Your link is valuable and I can create a flow on this...
I have a column named 'B' and it is a calculated field NOW() - [Due Date] so I put this in the FILTER QUERY --> B eq 'EXPIRED'
However, it failed and the Error Details is
The field 'B' of type 'Calculated' cannot be used in the query filter expression. clientRequestId : 7c92d7e20-a148.....
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
