web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate substringof not workin...

Power Automate

Answered

substringof not working on Dataverse list rows action

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Linn Zaw Win 2,996 on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Thanks @LinnZawWin

That worked as expected.

Was this reply helpful? Yes No

Join the conversation