Handling parameters in the List rows's filter query , which can sometimes be empty

Like (1) Share

Report

Posted on 26 Jan 2025 07:54:00 by PratikJadhav08

Hi guys , I need some help with this , I’m working with the Dataverse "List rows" action in Power Automate, where I use a Filter Query to filter data based on parameters coming from a Power Apps

The issue I’m facing is that these parameters can sometimes be empty, and I want to make sure this doesn’t cause any error

I have something like this , but no use

username eq '@{triggerBody()?['text']}' and
(owner eq '@{triggerBody()?['text_1']}' or owner eq null ) and
(status eq @{outputs('List_rows_to_find_Status')?['body/value']?[0]?['attributevalue']} or status eq null )

@WarrenBelz,@RandyHayes,@Pstork1,@timlee,@abm abm,@yashag2255

Categories:

Flow Mobile App

All responses (1)

Answers (1)

Verified answer

Michael E. Gernaey 41,474 Super User 2025 Season 1 on 09 Feb 2025 at 06:19:04

Like (1)

Report

Handling parameters in the List rows's filter query , which can sometimes be empty

Hi

So there are a couple of options and you may have this resolved already

But I would use a coalesce function so like

owner eq coalesce(inputvalue, inputvalue, null) or whatever you decide

But the above will make it so that nulls won't cause it to fail (with an error), and it will either compare a value or a null but let me know if you have any other issues.