OK, I’ve been having this issue, and not been able to fix it, but I think I finally figured out what is causing the issue, but not sure how to fix it.
I have a post with comments feature, and when someone comments it will send a notification to both the original poster, and anyone else who also commented. I have different workflows saying “Someone commented on your post” or “someone commented on a post you also commented on”. and make sure I remove people so they don’t get multiple if they are both the original poster and made previous comments.
I noticed I would get multiple notifications, but it was not until today I noticed the number of notifications was based on how many previous comments I made. I believe me saying "Search for Comments(which are linked with the Origional Post):each items’s Creator. Is not finding all commenters and adding them to the list once regardless of how many comments they made it’s adding the same commenters multiple times.
I want to look at all comments for the post, and anyone who commented will be added to the list to run on once. Instead, it’s adding people multiple times. How to I get it to only add each person once?
For this one, if I add Unique to the last one will it apply to both items in the merge or only the last one? I’m afraid if I do it in the middle it will have two unique lists but there might be some duplicates between the two unique lists.
However, if you are ever in doubt of the results in an expression, I’ve found the best way to be confident in the expression is to output the results as text onto a test page before using the expression in the app/workflow.