cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brucla1968
Helper II
Helper II

Filter array from excel table

Hello, thanks for opportunity to get help from community. I am new of power automate and I am trying to setup my first flows.

Here I have a problem with Filter Array. 

I have an excel file on OneDrive Business. This file contains two tables, one source and one destination. I need to copy rows from first table to second one. One criteria is used in order to select only those rows which need to be copied. This criteria is simple: check if one field (one column of excel table) is 0 (zero) value. Only rows with zero value have to be copied.

I setup flow without using filter and it runs correctly, but it copies all rows (no filter applied). 

I tried to insert Filter Array but in this case flow does not run (no error but no results) as no rows are copied at all.

Here basic flow without filter. This is ok.

01.PNG

Here the flow modified with Filter Array. This does not run (no row loaded)

02.PNG

Of course I checked that source table contains at least one row with fields PresQuestClasse = 0 (here below)

03.PNG

Thanks in advance for help

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Brucla1968 Go to expression tab and use string('0'). This is the correct way to use string. 

Hardesh15_0-1657549194661.png

 

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

View solution in original post

5 REPLIES 5
Hardesh15
Super User
Super User

@Brucla1968  Please check column type in your excel which is used for condition in filter array.  Run your flow then check the output of this action and see your column return type.

Hardesh15_0-1657519849922.png

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

 

Brucla1968
Helper II
Helper II

Thanks @Hardesh15 . I've checked the output and got this:

"ScoreForn":"0.106060606060606","PresQuestClasse":"0"},

I both tried in the filter to use 0 (zero as number) or "0" (as string, as indicated in the output) but nothing changed 🤔 

This is the filter  as appear in advanced mode: 

@equals(item()?['PresQuestClasse'], '"0"')

@Brucla1968 Go to expression tab and use string('0'). This is the correct way to use string. 

Hardesh15_0-1657549194661.png

 

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Brucla1968
Helper II
Helper II

Dear @Hardesh15 . Great! it works perfectly. Thanks. 

Helpful resources

Users online (3,778)