Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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. 

ChrisChong_0-1688524098761.png

I created variables in this attempt:

ChrisChong_1-1688524678036.png

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

Thanks for help.

Chris

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 2,982 on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    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

     

     

  • ChrisChong Profile Picture
    ChrisChong on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    Here is what I've tried unsuccessfully:

    ChrisChong_0-1688597799176.png

     

  • ChrisChong Profile Picture
    ChrisChong on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    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

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 2,982 on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    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»')

     

     

  • ChrisChong Profile Picture
    ChrisChong on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    In trying to trouble shoot the problem, I simplified the filter query as followed with the same results. Here is the filter:

    ChrisChong_0-1688591024674.png

    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.

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 2,982 on at
    Re: At wits end: How to build a List Rows filter of a Dataverse table

    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?

    LinnZawWin_0-1688567211247.png

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard