Hi,
From a Sharepoint list of items that have Approvers , want to send a reminded to those users when those items are near or past the due date.
As those list can be quite long, I just want to send one email per person with the list of items for them to review.
My flow get the items, remove duplicate users, format the key data I want to send in the email body.
For each unique user I want to filter their data. this return a blank array.
The "output" for "apply to each" is the unique approver from "Compose - Unique approver" it has 2 records .
The "output" for "Filter Array" is from "Select Items from doc List" it generate the Json as per the next screen shot.
The filter array in advance more looks like this @equals(item()?['ApproverEmail'], items('Apply_to_each'))
------------------------------------------------------------------------------------------
runtime scree shot
the Filter Array input is as expected from the "Selected Item Doc List", the output is empty!!
i have put the "current item" in a compose to see if they was any issues.
I have try to put the Json in a array 1st but I am still hitting the same issue.
is there way to debug what the filter array is actually doing?
It feels like there is something wrong with this : @equals(item()?['ApproverEmail'], items('Apply_to_each'))
Thanks in advance for the help.
