Announcements
12
I set up a scheduled flow to send automated emails using the 'Date' column in a list. It's basically a reminder message for stability testing on formula's. I've completed the flow and tested it several times with no error but I receive no reminders when I know I have formula's due for testing. Even when I hardcode my email as the recipient I am not receiving the automated email.
The flow and code are in the photo section.
All steps have green check marks. Here is what I'm trying to accomplish. I used power apps to be able to upload chemical formulations to a share point list. These formulations need to be checked once a week for four weeks. I'd like to be able to use the date column of my sharepoint list to send automatic reminders to the formulators that their formulas are ready to be checked. The code is trying to loop through the list and only find the formulas that are currently in the testing period.
Could you check in your run history, whether there is a green check on your "Send an email" action?
If not, track back to last action to see whether it outputs valid results.
Besides, I don't really understand your codes for filter array and condition step, what kind of filter would you like to do to your data?
Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
code for filter array: "@and(
greaterOrEquals(coalesce(item()?['Date'], '1900-01-01'), formatDateTime(utcNow(), 'yyyy-MM-dd')),
less(coalesce(item()?['Date'], '1900-01-01'), addDays(formatDateTime(utcNow(), 'yyyy-MM-dd'), 7))
)"
Code for condition step:
Hi @alex_m8519 ,
Check your flow run history to see whether the process go through the "Send an email" action or not.
If not, track back to last action to see whether it outputs valid results.
Meanwhile, could you make a further clarification on the filter conditions in your screenshots as it seems hard to understand what you would like to do with them...
Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
