Applying filter to For each flow

(0) Share

Report

Posted on by Veblitz

2,249

Here is my flow

1)when a file is created(properties only)

2)Get files (properties only)

3) For each

i)get file content // identifier from get files(properties only)

ii)Compose //name from get files(properties only)

iii)create file //In destination document library

I am able to copy documents from source document library to target document library but im unaware how to filter specific files from source document library as per above flow steps

Source document library

Title

Location.txt

Locations001.txt

supply.txt

Expected Output :

Target document library

Title

Location.txt

Locations001.txt

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Veblitz ,

I recommend you use filter array to get expected files.

Take your assumption as an example, I just want to get:

Location.txt

Locations001.txt

Best regards,

Rimmon

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help.

should we need to add the filter array step inside for loop and remove compose step as per below steps:

1)when a file is created(properties only)
2)Get files (properties only)
3) For each
i)get file content // identifier from get files(properties only)
ii)Compose //name from get files(properties only) ? do we need to remove this and add filter array as you shared ?
iii)create file //In destination document library

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Flow is getting failed.No dependents actions succeded

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Veblitz ,

Do you want to create files according to filtered out files?

If so, you should use body of Filter array in apply to each and use expression to get file identifier.

In addition, could you please show some screenshots about your failed steps?

Best regards,

Rimmon

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Further im getting below error after updating your recent inputs.
Error details:
From property value in the query action inputs is of type object .The value must be an array.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

im getting error in filter array steps.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Veblitz ,

Are you using same dynamic content as my screenshot?

If no, what is the value in the From field of Filter array?

Best regards,

Rimmon

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

I tried using your screenshot for dynamic content in filter array
outputs('Get_files_(properties_only)')?['body/value']

Also ,now im using below one in my flow for filter array
outputs('Get_files_(properties_only)')

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Veblitz ,

'outputs('Get_files_(properties_only)')' returns an object. This is why filter array shows 'From property value in the query action inputs is of type object .The value must be an array'.

You should keep the previous dynamic content.

outputs('Get_files_(properties_only)')?['body/value']

Did the below error appear when you use same dynamic content as my? If so, could you please show some screenshots about it and details of actions?

Best regards,

Rimmon

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I am not getting same error also i used same dynamic content as you share,still not working

Was this reply helpful? Yes No