Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
trice602 398 Super User 2025 Season 2
David_MA 331 Super User 2025 Season 2
Expiscornovus 203 Most Valuable Professional
