Unanswered

filtering with a parameter from a button

(0) Share

Report

Posted on by fklatecki

Greetings,

I am bring a Parameter 'string' from a button select through from compose to initialize no problems. I have trying to filter the list items, and I can see the list item. I am trying to filter by comparing a field <new_name> against a the string, using the function "contains". For example the new_name = 'Test Company - date", and the parameter string would be "test". Looking for the result of 'Test Company - date'. I am using the Filter array, because as I understand the Filter Query (odata) does not support a "contains" function.

Unfortunately, the results are not filtered at all by the Filter Query. Thoughts???

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Re: filtering with a parameter from a button

Hi @fklatecki ,

What is the problem you are currently experiencing?

Best Regards,

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report

Re: filtering with a parameter from a button

Greetings,

It appears that the filtering is not working as designed, the input data is appears to unaffected by the filters I believe I have used.

When hard coding Filter Query, rather than a variable, the process works as designed.

new_name eq 'xxxxYYYY Interiors - 10/22/2019 2:48 PM ' ("new_name" is the field from the source data, the xxxxYYYY is valid field value in "new_name".

Thoughts?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: filtering with a parameter from a button

Hi @fklatecki ,

It is workable to use variables as a filter in Filter Query. However, you need to note the type of field. If the type is string, you need to add single quotes outside the variable.

Please refer to this blog and get more details about Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

Best Regards,

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report

Re: filtering with a parameter from a button

Thank you for your suggestion, however when I created a filter query for a substringof as shown in the link you provided. This is the failure message generated by the flow , substringof('@{variables('Dealer_name')}',new_name), where variable 'Dealer_name' is part to the field, 'new_name'.

{
"status": 400,
"message": "An unknown function with name 'substringof' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.",
"source": "ixxxxxx.dynamics.com",
"errors": [],
"debugInfo": "clientRequestId: 53977d26-0eb6-4a01-b035-69509f7e9068"
}

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: filtering with a parameter from a button

Hi @fklatecki ,

I think Substringof() is not supported. In my previous tests, I also reproduced the same error.

So, directly using Filter Query to determine whether the specified field contains the specified string is not possible.

The current method we can consider is to use Condition or Filter array directly.

Best Regards,

Was this reply helpful? Yes No
fklatecki 65 on at

Like (0)

Report

Re: filtering with a parameter from a button continuting with no solution

Greeting,

This issue continues with resolution. Is this bug in Power Automate. The formula is accepted by the filter array process has no affect on the output, as though the Filter Array did not exist. Is there a work around? Is there new develop planned?

Regards,

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Re: filtering with a parameter from a button continuting with no solution

Hi @fklatecki ,

Have you checked whether there are eligible records in the entity?

Are the formulas shown in the screenshot generated after you click advance mode or are you manually configured?

If not, you can try to use Dynamic content to configure the Filter array, provided that there are eligible records in the entity.

Best Regards,

Was this reply helpful? Yes No
CW 1,044 on at

Like (0)

Report

Re: filtering with a parameter from a button

I wonder if it should only be; contains rather than @contain

Was this reply helpful? Yes No