Power Automate Filter Array, no column names in the array

(0) Share

Report

Posted on by rayblair

Good Morning all

FYI I am in GCC..

I have an very large text file that has 300,000+ records. I am trying to import them into a Dataverse table. I have the import working fine. The text file contains many records, that should be excluded since they are marked as deleted.

All of the filter array examples I see go by a Column Name. My file has no column names.

The examples show this: item()?['Deleted'] I have tried: item()?[0]. and item()?['0']. and item()[0].

The error is:

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@not(contains(item()?[0], 'D'))' failed: 'The template language expression 'not(contains(item()?['0'], 'D'))' cannot be evaluated because property '0' cannot be selected. Property selection is not supported on values of type 'String'.

Categories:

General topics

Filter Array 2.jpg

Filter Array.jpg

I have the same question (0)

All responses (10)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Instead of using the [0] index to get the first character try using Starts With instead of Contains.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
rayblair 10 on at

Like (0)

Report

Thanks, Pstork1.

Does not seem to filter

Filter Array With...

Filter Array With...

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report

Could you show a "deleted" record in your text file?

Was this reply helpful? Yes No
rayblair 10 on at

Like (0)

Report

VictorIvanidze,

attached

Filter Array With...

Filter Array With...

Was this reply helpful? Yes No
Verified answer

VictorIvanidze 13,073 on at

Like (0)

Report

It works fine for me:

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

Did you try to run my flow?

Was this reply helpful? Yes No
rayblair 10 on at

Like (0)

Report

VictorIvanidze.

Yes I was able to get that to work.

Now I am trying to get another filter where records with a dash in the second column are excluded.

See the attached screenshot

Filter Array DASH...

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (0)

Report

contains(split(item(),',')[2],'-')

Was this reply helpful? Yes No
rayblair 10 on at

Like (0)

Report

VictorIvanidze

Thanks much, both of the individual filters bring the records wanted.

My hurdle now is I want both conditions to apply.

I have this now.

@or(
   not(contains(split(item(), ',')[0], 'D')),
   startsWith(split(item(), ',')[1], variables('varZeros'))
   )

varZeros is "0000"

The problem is that both conditions apply to a single row.

Here is what I mean

Exclude the first row as it has a "D" in Column0 even though it does have 4 zeros in Column1

Exclude the second row as it does not have four zeros or a "D"

Include 3 and 4 as they have four zeros and no "D"

"D,0000216813,PRHD,
",551000-001,PRHF,
",0000216834,PRHD,
",0000179169,PRHD,

I have researched but can not locate my scenario...

Thanks

Was this reply helpful? Yes No
VictorIvanidze 13,073 on at

Like (1)

Report

A bit too many questions in a single thread, don't you think so?

Please close this thread and create a new one.

Was this reply helpful? Yes No