Answered

Filter array from excel table

(0) Share

Report

Posted on by Brucla1968

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.

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

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

Thanks in advance for help

Categories:

General topics

All responses (5)

Answers (1)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

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

@Hardesh /Gopenly.in
Brucla1968 70 on at

Like
a
(0)

Report
Copy link

Link copied!
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 🤔
Brucla1968 70 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the filter as appear in advanced mode:
@equals(item()?['PresQuestClasse'], '"0"')
Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

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

@Hardesh /Gopenly.in
Brucla1968 70 on at

Like
a
(1)

Report
Copy link

Link copied!

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