I have a list that contains the following columns
- Employee Number
- Employee Name
- Department e.g HR, Finance...etc
- Status. e.g not start, pending, complete ...etc
I want a flow that count the items like the following example
with million thanks
Please use Get Items and then Apply to each. For counting you need a variable of type int.
1. Get items
2. Initialize a variable- Int type
3. Apply to each- supply value from get items
4. Inside apply to each- Increment variable by 1.
you can manager status column in get items filter query/filter array for each department
Thank you for this
Please note that I need also to send these numbers(count) in a table through email. and the table should be in the body of the email
After get items use apply to each action in that supply value from get items. Inside apply to each use increment variable.
You have initialized variable of type int but you your value is not typ of int (use zero )
You need to use initialize variable action out side loop . Can you please use Initialize Variable after Get Items action.
the below photo shows what i did till now
would you please help me by sharing me a photo where i should do each step?
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.