Get items sharepoint - String containing title

(0) Share

Report

Posted on by ND3

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!

I have the same question (0)

All responses (1)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report
Re: Get items sharepoint - String containing title

Dear N,
I can think of 2 ways to help you futher:
Filter the Get items array from the Action itself (view screenshot below).
Filter the Get items array by a follow up action 'Filter Array'.
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

Was this reply helpful? Yes No