Power Platform Community Forum Thread Details

Hello,

I have a flow that fetches approvals from Dataverse whose flows have expired. The name of each expired approval (as well as some metadata) is appended to a table, which is then sent to me if the table contains any data.

When it ran recently, it sent a strange email, which contained values which should be excluded by the OData query (statecode eq 0 and createdon le 2025-05-14T17:00:04.7734642Z):

To make things even stranger, when checking the corresponding flow run (from the same date and time as the email), it shows that no approvals were found and that no email was sent:

Does anybody know why there's such a significant difference between the flow's recorded history and the actions the flow completed?

Thanks,

Josh Sampson

Categories:

Building flows

Make sure the flow is not running on different environment so maybe test/dev environments same flow is also on and the email was actually send there.
Check also that there isn't a flow outside the solution running parallel and maybe that sent that mail (and maybe that flow did not have OData filter)

I would add workflow run ID in the email so you can see that if next time this type of situation happens to make sure the mail was sent from the same flow run log that you are looking at.
So add this: workflow()?['run']?['name'] -expression to your Send an email (V2). Then it produces ID similar to this: 08584517284902445282099162909CU114
Then in the Run history on specific flow run the end of the URL will have that id so you can check if they match.

And of course if in the next email you get doesn't have the id in it then the email is being sent from different copy of the flow that you need to find and turn off.