Collect multiple amount of sharepoint objects and send them in one email

(0) Share

Report

Posted on by Talko

Hi,

I'm trying to build a flow where I have a sharepoint list called Inventory,

There I got 3 columns -

Item Name, Quantity, Minimum Quantity.

I built a flow triggered by recurrence, for every day.

I did manage to send an email but the problem is that I get an email for each and every item.

What I want is, to get 1 email once every day, that combines all the items that are equal or below the minimum quantity + the current quantity of each item and the minimum quantity of each item.

I'll be glad for some help,

Thanks!

All responses (4)

Answers (1)

Talko 88 on at

Like (1)

Report

Re: Collect multiple amount of sharepoint objects and send them in one email

It works! Thank you!
Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Re: Collect multiple amount of sharepoint objects and send them in one email

Change your parameters in Condition as below for a try:
int(item()?['Quantity']) int(item()?['MinimumQuantity'])
Talko 88 on at

Like (0)

Report

Re: Collect multiple amount of sharepoint objects and send them in one email

Hi @v-wenjuan-msft
Thank you for your reply!

I followed your instructions and I get this error:

This is my flow for reference:

What am I doing wrong?
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Re: Collect multiple amount of sharepoint objects and send them in one email

Hi @Talko ,

Initialize an array variable above "Apply to each", and append objects to it once the item match your condition.
Then you will get an array built by matched items. You can create an HTML table and add it to your email.
I made a demo for your reference:

Here's the email I received:

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.