Answered

Filter rows with In function

(0) Share

Report

Posted on by DennyB

I am trying to use the List Rows (Dataverse) action with the Filter rows parameter.

I have a list of ID's which i need to filter on. My list looks like this: ['600268253','600268266']. To accomplish this i tried to use the In function. So i filled my filter like this:

Microsoft.Dynamics.CRM.In('Item Number',['600268253','600268266'])

This resulted in the following error:

An unknown function with name 'Microsoft.Dynamics.CRM.In' was found. This may also be a function import or a key lookup on a navigation property, which is not allowed.

Anyone who knows how to use this filter?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mbarbosa 146 on at

Like (0)

Report
Copy link

Link copied!

Hi @DennyB ,
where are you trying to use that function? It seems that is not recognizing the function.

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (3)

Report
Copy link

Link copied!
@DennyB

'Item Number' in your filter is supposed to be the logical name of the column (all small with prefix. e.g. xyz_itemnumber). You are also missing the PropertyName= and PropertyValues=. Please replace the xyz_itemnumber in the following filter with the logical name of your column.

Microsoft.Dynamics.CRM.In(PropertyName='xyz_itemnumber',PropertyValues=['600268253','600268266'])

I recommend using the FetchXML Builder tool to build the filter query if you are not familiar with the filter operators. Here are a couple of blog posts from the community on how to use the tool to generate the filter rows parameter.

https://blog.magnetismsolutions.com/blog/nickchin/2020/05/07/power-automate-flow--making-the-filter-query-easier

https://saralagerquist.com/2019/11/13/be-lazy-filter-list-records-in-power-automate-with-fetchxml-builder/

If it is still now working, please show us the screenshot of your Dataverse List Rows action.

1 people found this reply helpful.

Was this reply helpful? Yes No
DennyB 9 on at

Like (1)

Report
Copy link

Link copied!

Thank you!

I actually tried to use the parameter names before, but that didn't work. I think using the logical name did the trick.

Was this reply helpful? Yes No