Unanswered

Send an email every day with any product line items in a spreadsheet that are less than 10% of initial inventory. receiving error message for the ForEach

(0) Share

Report

Posted on by MG_User

Have attempted to build an automation to send an email once a day for any items that are low in inventory. Below is outline of what has been done so far receiving error message for the ForEach. action. have attempted to use the apply to each as well. the data resides in an Excel spreadsheet in Sharepoint.

Categories:

General topics

All responses (4)

Answers (0)

Sort by

Anil_g 668 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@MG_User

May I know what is used in for each..as per error the value you provided to loop is wrong

ideally you just need to select the output of list of rows in table

cheers
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MG_User ,

Could you please show the expression in Condition?

If you're having trouble checking current inventory are less than 10% of initial inventory, please provide outputs from the current inventory and original inventory in List rows in a table and I'll provide you with a solution.

I recommend you try Filter array and Create HTML table.

Then insert the HTML table in email body. The HTML table contains items that are less than 10% of initial inventory.

Your current flow will send email for each item that is less than 10% of initial inventory.

Best regards,

Rimmon
MG_User 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the comments and any help.
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MG_User ,

How is the situation now? Does my method work?

Thanks for screenshots.

I also need to check outputs of "Avail.." and "Initial Inventory" of List Rows in a table. The data type of them in outputs determines how to set the Condition.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

If you have another problem, please post it in new post.😀

Best regards,

Rimmon