cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidMLCarr
New Member

How might one apply a STDEV (Standard Deviation) function against a column returned by a List Records action?

Hi Power Automaters,

I have a flow that returns a dataset.  I can count and sum all records in this dataset, but after reviewing all "Expressions" I didn't see any advanced mathematical function set.  Looking specifically for SQRT or STDEV function capability.  (If one doesn't exist, then an example of how I can pass a list into Excel, and get Excel to do a calculation would be equally awesome... 😉 

Thanks,

Dave

2 REPLIES 2

@DavidMLCarr 

Hey there.  So, maybe a couple of options.  My first thought was to call a PowerShell script from Flow.  Here's a thread on how to do that, and then here's a post with a PowerShell script for Standard Deviation.

 

I'm guessing you may not even need to do that if you are already doing Azure functions.  There's probably some whiz-bang way to just do it there.

 

Either way, those should work.

-Ed-

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Thanks Ed.   I'll try those ideas out after vaca...   I must say I'm really surprised by the lack of mathematical operators on a collection... Power Automate 2.0?

Thanks again

Dave

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,461)