Trouble filtering an array

(1) Share

Report

Posted on by scoyphenson

Hello, clever people. I am trying to build a flow that will copy the original version of documents from one SharePoint folder to another. Most of the flow is working fine, but I cannot, for the life of me, succeed in filtering so *only* the original versions are pulled.

Here is my flow:

I have tried filtering by every imaginable way, including "IsCurrentVersion" eq "False," VersionName, and VersionID. Nothing seems to sort the version 1.0 documents from the rest.

I am attaching a PDF with samples of the Select output and Filter array input and output. I would be very grateful if someone can tell me where I've gone wrong. Thank you!

Categories:

Business Process Flows

Input and output ...

I have the same question (0)

All responses (5)

Answers (0)

abm abm 32,535 Most Valuable Professional on at

Like (0)

Report

Trouble filtering an array

Hi

Thank you for the reply.

Try item?['VersionLabel'] I can see you using the '{ }' brackets

Was this reply helpful? Yes No
scoyphenson 12 on at

Like (0)

Report

Trouble filtering an array

I think the zero at the beginning of the output is because it's first in the array.

Thank you very much, but I'm already using item()?['{VersionLabel}'] to filter.

Was this reply helpful? Yes No
Suggested answer

abm abm 32,535 Most Valuable Professional on at

Like (0)

Report

Trouble filtering an array

Hi

Thanks.

The below is your select output not sure why it starts with 0.???

0.{"value":[{"Created":"2022-01-31T19:20:31"
IsCurrentVersion":true
VersionId":1024
VersionLabel":"2.0"

Anyway try the filter with item()?['VersionLabel']

Was this reply helpful? Yes No
scoyphenson 12 on at

Like (0)

Report

Trouble filtering an array

Is this what you meant?

Was this reply helpful? Yes No
abm abm 32,535 Most Valuable Professional on at

Like (0)

Report

Trouble filtering an array

Hi

Could you please show me your Select action step mappings?

Thanks

Was this reply helpful? Yes No