
I have a excel table:
| SearchName | |
| John Peters | john.peters@flow.com |
| john.peters@flow.com | john.peters@flow.com |
| Adam Smith | adam.smith@flow.com |
I have built a flow that searches the incoming email for the emails and names and return a filter array.
@Anonymous(contains(tolower(triggerOutputs()?['body/subject']), tolower(item()?['SearchName'])), contains(tolower(triggerOutputs()?['body/body']), tolower(item()?['SearchName'])))
For example if I receive an email which contains the name of John and his email plus the name adam smith, the array returns three results.
I have in an earlier step created a task in Planner, but now i want to assign the task to Adam and John.
How to extract the unique values from filterarray and use these to assign the task?
And DO i need unique emails or will Planner detect duplicates and only use one?
I am stuck...
SOLVED it myself. The task is able to ignore duplicate users.