cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Iro_
Helper I
Helper I

Filter Array: property doesn't exist

The following flow was working fine until a few hours ago. Then we just added data (about 2K) to the dataverse table.

Iro__0-1634129755307.png


Here is the input: 

 

Iro__1-1634130071451.png

 

 

And the error:

The execution of template action 'Iban_List' failed: The evaluation of 'query' action 'where' expression '@item()['zst_iban']' failed: 'The template language expression 'item()['zst_iban']' cannot be evaluated because property 'zst_iban' doesn't exist, available properties are '@odata.type, @odata.id, @odata.etag, @odata.editLink, zst_vatnumber, zst_vendorno, zst_vendorname.

Is there a limit to the number of data it can filter?
Also, some rows have the iban property empty. Could this be causing the issue?

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @Iro_,

 

I see you are missing a ? character in your expression. Can you try this first:

item()?['zst_iban']

 

If that still doesn't work you could try using and if and empty:

if(empty(item()?['zst_iban']), 'Not available', item()?['zst_iban'])

 

View solution in original post

2 REPLIES 2
Iro_
Helper I
Helper I

I think the problem is NULL values.

I need an expression in order to exclude null values while filtering...

Expiscornovus
Super User
Super User

Hi @Iro_,

 

I see you are missing a ? character in your expression. Can you try this first:

item()?['zst_iban']

 

If that still doesn't work you could try using and if and empty:

if(empty(item()?['zst_iban']), 'Not available', item()?['zst_iban'])

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,250)