Answered

Condition not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Currently, I am trying to automate getting a file from the latest folder in Sharepoint Library. So far, I am able to get the Name and Path of the latest folder but it is the subsequent steps that I have trouble with.

1. Get files (properties only)

2a. Select operation --> outcome: gets latest folder in library.

Map:

Name: item()?Name

Path: item()?Path

b. initialise varArr with String values.

3. Compose outcome. inputs: first(body('Select')?['Name'])

as the first record is the latest folder

4. Filter array

From varArr

item() is equals to outputs('Compose')

5. Condition

length(body('Filter_array')) is equals to 1 // folder name should only match with one element in the arr

If anyone can spot my mistake, please do advise on what I should change. Thank you

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 33,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

I think the closing parentheses of the first function is in the wrong location. Can you try this expression instead in the Compose?

first(body('Select'))['Name']

The rest looks alright. I tested with the below config in my dev environment.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus ,

Thanks for your response. I have tried out what you have suggested and my condition output is still false. I have a feeling there might be something wrong with step 2. When the Filter array operation is executed, the output is an empty array. I am not too sure what is the issue with it. 😔

Was this reply helpful? Yes No
Expiscornovus 33,773 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Can you double check or share screenshots of the outputs of the Select, Initialize variable and Compose actions of your flow run?

The comparison would be case sensitive. Make sure there is not a different casing in values and they are exactly the same.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus ,

I just spotted my mistake. Thank you so much for your help!

Was this reply helpful? Yes No