You’re offline. This is a read only version of the page.
34
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!
Dear N,
I can think of 2 ways to help you futher:
Both should get you the results you need.
For further details on how to configure the filter expression used, suggest you try to ask 'ChatGPT' and just try what works for you.
Hope the suggestion helps,
Happy flowing,
Koen
Share
Report
All responses (
Answers (
