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 )
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.
Was this reply helpful?YesNo
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.
84
Share
Report
All responses (
Answers (
