I have a flow in flow designer where I am trying to send an email to notify that the events coming from SolarWInds are lower than expected for the day before.
I have a trigger that runs the flow once a day at certain time
then I have a "look up records" action for the em_event table that looks for all records created yesterday where the source = SolarWInds but the count pill for this action is always returning a zero value. I wonder if you guys can help me find what I am doing wrong. here is a screenshot of the action in question. the usual count for an average day is a little over 40,000 records. so I am setting a condition to send an email if the count is less than 10000. with that in mind, can you advice the value I need for the max results field? I am not sure if I am using that correctly, I have it set to 10000. again the problem is when I run this flow, the count always comes back as zero.
the next action in my flow is an if statement that uses the count pill for the previous action followed by a send email action.
lastly, I am not sure how to finish the flow. do I need to put an action at the end of the flow to indicate the end or something like that?
I will deeply appreciate your help!
Efra
