Hello
I'm building a flow where i want to get items from a sharepoint list, but only the ones where a certain (long) string contains the exact characters from the sharepoint list. Next i want to send an email to the corresponding email adress in this list.
Example:
string: kfdjmkfjdkjfqkfdhdeioznxbhozn,eihdà zkojArras,DariuskkddokdnnoldnPrince,Phillipedkjsbuxoznwllcncnjhjgkhfjdheztreeytrkbk
(i have this string contained in a compose action)
list:
| Title | field_1 |
| Doe,John | Johndoe@hotmail.com |
| Arras,Darius | Arras_darius@gmail.com |
| Armstrong,Louis | Armstrong@.... |
| Prince,Phillipe | HRHPhillipe@gov.eu |
So sending 2 separate mails to Arras_darius@gmail.com and HRHPhillipe@gov.eu
I want to use ODATA filters because the list is very long, as opposed to using filter array.
I've tried using contains(outputs('compose'), Title); substringof (outputs('compose'), Title); substringof (outputs('compose'), item()?['Title']); ...
Is there a way to make this work?
Thanks for any help!


Report
All responses (
Answers (