Announcements
Good Morning,
I am trying to build a flow that calculates the average of a SharePoint list column. I want reduce the length value by 1 if I get zero value in the column from Get Items.
Example
Question 1
1
5
8
0
6
Please Help
Hi @Caleb62881177 ,
Do you want to subtract one from the list length when the value of your Question column is equal to zero?
If so, I have a test for your reference.
In my scenario:
The Compose Expression: length(body('Filter_array'))
Best Regards,
Sunshine Gu
@v-yetonggu-msft That is an interesting solution. I took a longer route and created a Get Items with odata filtering. Using the following Question1 ne 0. That helped me filter out the 0s in the column.
@v-yetonggu-msft Thank you. You gave me an idea for a future project.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 250 Super User 2026 Season 1
Expiscornovus 222 Most Valuable Professional
Haque 174
