I have a SharePoint list to log each workers extra hours.
Then I created a Flow that triggers once a month to make some calculations with those hours and send me an email.
Let's say my list is something like this:
Right now, my flow would take every row and do the calculations with all the values. But what I want is to be able to run it once for each diferent worker, so 3 times: Susan, James and Mike.
Any idea how can I achive that? Maybe start with a SharePoint query and store the unique values for the field 'Worker', then run the rest of the flow for each value?
Go to Solution.
I think that could be a solid strategy. Something like this:
Then you can do the calculations for each element by doing an "Apply to Each".
I recommend fetching only the values you need by filtering by the name by doing the following:
Is this what you need?
If I have answered your question, please mark your post as Solved.If you like my response, please give it a Thumbs Up.
View solution in original post
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.