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
Solved! Go to Solution.
@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.
@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.
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.
Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.
User | Count |
---|---|
16 | |
16 | |
14 | |
9 | |
8 |
User | Count |
---|---|
27 | |
26 | |
24 | |
23 | |
15 |