Correct use of "substringof"

(0) Share

Report

Posted on by da1ve

340

Hi guys,

I am trying to filter a "Get Items" action using substringof. Is it possible to substitute the condition value with a variable rather than hard text? So for example, instead of:

substringof('help with printer',Title)

we use a variable like this (email subject line):

substringof(triggerBody()?['subject'],Title)

or:

substringof(variables('subject'),Title)

This is the flow:

Hoping to use the filter query within the Get items action

Thanks,
David

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @da1ve ,

Please try:

Best Regards,
Dezhi

Was this reply helpful? Yes No
sofiang 14 on at

Like (0)

Report

Hi,

You could use variables for both column and search term. The important part is to put quote marks surrounding the text to search for.

Cheers 🙂

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report

Hi @sofiang & @v-dezhili-msft ,

Thanks for your help. It seems it either isn't working as expected or my scenario wont work. So if I look at my trigger action, the subject is "re: bnm"

Then on my filter query I am using:

Which shows the correct data:

But the outputs show nothing:

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @da1ve ,

Is your flow wrong?
If there is no error, it seems that there is no record containing "re:bnm" in the Title column in your list.
Could you please show some data for the Title column in your list?

Best Regards,
Dezhi

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report

@v-dezhili-msft ,

So the title column has an entry of "bnm"

What I'm trying to achieve is filter out the records containing text. So when a new email is received and the subject of the email is "re: bnm" - I want the filter query to match the title record (bnm) because the email subject contains text of the title column (not an exact match).

Hope that makes sense?

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @da1ve ,

Unfortunately, if the second parameter of substringof in the filter query is the column name, the record that contains the first parameter in the column is found.
If you want to find the fields contained in the string, I suggest you use filter array to achieve.

Best Regards,
Dezhi

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report

Thank you @v-dezhili-msft that worked perfectly

Was this reply helpful? Yes No