Unanswered

substringof not working on Dataverse list rows action

(0) Share

Report

Posted on by rbn_nue

Hi Folks,

I'm trying to apply substringof filter in Dataverse list rows action and it returning below error:

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.

contains also not working.

Can any one suggest a fix.

Thanks,

Robin

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Linn Zaw Win 2,996 on at

Like (1)

Report
Hi Robin
The equivalent filter operator for Dataverse is contains()
Here is an example
contains(crf0e_incidentnumber, 'A6788')
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/

Was this reply helpful? Yes No
rbn_nue on at

Like (1)

Report

Thanks @LinnZawWin

That worked as expected.

Was this reply helpful? Yes No