Length Condition False Positive

[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.

Kind regards,

Teresa

[Zacharie_Cortes · Accepted solution]

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.

[ManishSolanki · Accepted solution]

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

[tagustin2020]

@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

[Zacharie_Cortes]

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

[tagustin2020]

@ManishSolanki 

@Zacharie_Cortes 

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

Teresa

[Zacharie_Cortes]

@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/ 😉

[tagustin2020]

@Zacharie_Cortes 

Thank you, Zacharie. I appreciate the tip 😀

Teresa