Unanswered

At wits end: How to build a List Rows filter of a Dataverse table

(0) Share

Report

Posted on by ChrisChong

Gooday/eve to you all:

At wits end because I've spent last two weeks struggling--watched every YouTube vid; Google/Bing/GPT search unfruitful. Help please?

Here's the problem:

The first filter **(cra31_adressecourriel ne null)** on its own works and retrieves 4000+ records from the table.

The other filters produce 0 records and should produce a few hundred records.

I created variables in this attempt:

Can you suggest or point the way for this "citizen developer" please?

Thanks for help.

Chris

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!

What is the data type of the cra31_rgionadministrative column?
Can you please show the filter from one of the flow runs (as in the screenshot below) to see the complete filter with the variables from the input parameter?

Was this reply helpful? Yes No
ChrisChong on at

Like (0)

Report
Copy link

Link copied!

In trying to trouble shoot the problem, I simplified the filter query as followed with the same results. Here is the filter:
The 1st line on its own produces 4000+ records. Adding the 2nd line, erroneously produces 0 records; there should be at least 7 records.
The column type of both fields is text.
I hope this provides enough info to discover what I'm doing wrong.

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!
After simplifying the filter query, you might have updated the filter operator of the 2nd line. The operator in this screenshot becomes "eq" while it was "contains" in the original screenshot. (maybe that's why it returns 0 records instead of 7+ because there is no record with exact match for the lastname = "ch")
Can you update that part back to
contains(cra31_lastname, '«vLastN»')

Was this reply helpful? Yes No
ChrisChong on at

Like (0)

Report
Copy link

Link copied!

Thank you. You are correct, that was my mistake.
I meant to explain that when the "contains(cra31_lastname, '@{triggerBody()['Listrows_Filterrows_3']}')" is empty it returns 0 records rather than the 4000+ it should return. (By the way, the last name field is blank because these are essentially new records.)

Any idea how to handle this situation, when the contains(cra31_lastname, '<vLastName>') is empty or blank?
Thank you again.
Chris

Was this reply helpful? Yes No
ChrisChong on at

Like (0)

Report
Copy link

Link copied!

Here is what I've tried unsuccessfully:

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report
Copy link

Link copied!
That will be like this
cra31_adressecourriel ne null and (contains(cra31_lastname, '@{triggerBody()['Listrows_Filterrows_3']}') or cra31_lastname eq null)
You can write filter conditions easily with FetchXmlBuilder tool.
https://saralagerquist.com/2019/11/13/be-lazy-filter-list-records-in-power-automate-with-fetchxml-builder/
https://blog.magnetismsolutions.com/blog/nickchin/2020/05/07/power-automate-flow--making-the-filter-query-easier

Was this reply helpful? Yes No