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!

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Talko 90 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

v-wenjuan-msft Microsoft Employee on at

Like (0)

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

Was this reply helpful? Yes No
Talko 90 on at

Like (1)

Report

It works! Thank you!

Was this reply helpful? Yes No