Answered

Length Condition False Positive

(0) Share

Report

Posted on by tagustin2020

Hello,

I am working on a weekly reminder flow for items that are pending approval. For the sake of testing, I'm manually triggering it. Even though my SharePoint list currently has no open items to be approved, the Length statement is registering as 1 which causes an empty email to be sent. I would appreciate if someone could take a look at my flow steps and expressions and let me know what I am doing wrong. Thanks!

I've tried writing the Filter Query with eq the two statuses where something would be considered pending. This doesn't generate a different result from the outcome of the steps below.

I've tried writing the Length statement with just 'Get_items', 'Get_items/body', and 'Get_items/value'. The result generated is always 1.

The first Output in email step is the Compose statement, the second is the html table.

The result of the email is an item count of 1, but no html table showing any items. Why is it computing as 1 when there are no open items? I'm hoping I'm just missing something obvious and that it isn't a bug. Thanks in advance for your help.

Email Result.png

Kind regards,

Teresa

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

Hello @tagustin2020 ,
Have you tried to look at the JSON output of your "GET ITEMS" ? Maybe you will find the gost line ...
PS : if the JSON in not readable in the browser, consider installind an add-in to your browser that can format JSON a way than you can read it.

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,169 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @tagustin2020

The formula createArray('Get_items/value') create an array with 'Get_items/value' as an element so it always returns 1 when calculating its length.

Please try using the below expression in 'Compose' action to get the correct value:
length(outputs('Get_items')?['body/value'])

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report
Copy link

Link copied!

@Zacharie_Cortes

Hello Zacharie,

Thank you for the quick reply. The JSON output is not accessible in the flow run and I don't have permissions to install any programs on my work computer so I'll have to submit an IT ticket. Since this might take awhile, I'll go ahead and accept this suggestion as a solution for now. Have a good day!

Teresa

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

The ugliest solution that works too is to make a "for each element" loop where you increase a variable

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report
Copy link

Link copied!

@ManishSolanki
@Zacharie_Cortes

Thank you, Manish! That did the trick. I really appreciate both of you responding so quickly. Have a wonderful day!

Teresa

Was this reply helpful? Yes No
Zacharie_Cortes 170 on at

Like (0)

Report
Copy link

Link copied!

@tagustin2020 :
If you ever acces the json, you can read it by copy/pasting it in an online formater as this one : https://jsonformatter.curiousconcept.com/ 😉

Was this reply helpful? Yes No
tagustin2020 on at

Like (1)

Report
Copy link

Link copied!

@Zacharie_Cortes

Thank you, Zacharie. I appreciate the tip 😀

Teresa

Was this reply helpful? Yes No