I am working on flow that will email my procurement analyst when the number of PCs in stock for a given "Category" falls below 5.
The "Category" values I am focusing on for now are: Everyday and Tablet. I have other types of PCs such as Engineering, Mobile Engineering, etc. I am assuming if I can get a flow that will work for two types of PCs, it will work for all of them.
I have an array initialized with ["Everyday", "Table"] I would like my flow to use the current array value as an input to my Filter for Get Items so I can count the number of PCs for a given Category such as "Everyday" and use that value in a Condition which will send an email if the number of PCs in stock falls below 5.
Here is a screen shot of my flow.
When I run the flow I get this error message:
Can someone help me understand why the flow appears to be using the entire value in the array instead of the individual items in the array?
I do have a view setup that shows the number of PCs in stock for my categories. If there is a way to use the view to make my flow more efficient I would be happy to have someone point me in the direction to use my view. Here is a screen shot of my view.
I am new to Flow and appreciate your help!
Your issue is you are comparing with an array against a column value?
Please see this post below how to compare an array vs text varaible.
Also the correct REST API syntax is as follows:
Above I am checking Title column contains 332. That %2C is required before the column name.
I have modified my flow as shown below. When I run the flow I get a total of all available PCs, which is 134. My goal is to get a count of available PCs in each category as shown in the screen shot. If any count of available PCs for any particular category falls below a given thresh hold (say 5 PCs) then send an email to the procurement analyst. Based on the data below I would like my flow to send either one email stating that the inventory levels for the "All In One" and "Desktop" categories are below the thresh hold or two emails, one for "All In One" and one for "Desktop" stating that the inventory levels are below the threshold.
When I run this flow:
I do not get an email because the flow is summing the values for all categories which is 134. I would like to loop through each Category find the total in each category and send an email for any Categories that have an inventory level of less than 5.
Is there a way for a flow to look at the values in the Group By Sharepoint view and access the Group By count directly instead of having the flow execute the computation?
Thank you all for your assistance!
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.