cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Sum SharePoint list column with condition based on second column

Hi,

I have a stock out list to monitor the use of cleaning chemicals:

 

stockoutlist.png

 

What I want to do is send an email at the end of the month which sums the quantity issued of each item for the last month and puts it into an html table with Title in one column and TOTALQtyIssued in the second with the table covering one calendar month. 

 

I have managed to create a flow that will email me the sum for a single ChemID number that I manually input, but I don't know how to make it automatically do it for all used ChemID numbers.

 

stockoutlist6.png

 

How do I get Flow to sum the values I need? Any help would be much appreciated, thanks.

Izzy.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Sum SharePoint list column with condition based on second column

Hi @IzzyWizz

 

Glad that your problem has been solved.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Sum SharePoint list column with condition based on second column

Hi @IzzyWizz ,

 

Could you please explain more details about the requirement so we could better understand you and provide the workaround?

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Helper III
Helper III

Re: Sum SharePoint list column with condition based on second column

Hi,

Thank you but I have managed to generate the totals data that I need via the PowerApp that I use to input data into the Sharepoint lists. It just seems too complicated in Flow.

Izzy.

Highlighted
Community Support
Community Support

Re: Sum SharePoint list column with condition based on second column

Hi @IzzyWizz

 

Glad that your problem has been solved.

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (5,686)