I have a simple workflow to send out a daily email reminder for tasks that are due today from a Sharepoint Tasks list. My Flow has this error: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_2')' is of type 'Object'. The result must be a valid array.
Please see screenshot of my current flow job:
The 'current item' in your inner Apply to each is an object, not an array. You should be able to delete that and do you action inside the outer Apply to each.
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
I'm pretty sure the innter Apply to each is there becuase it's a multivalue person column.
See my current solution:
I've added "Build Table Rows", then added the section "Scope to get items due in 1 day". Please see the screenshots."Build table rows" variable
Then
User | Count |
---|---|
102 | |
40 | |
29 | |
23 | |
16 |
User | Count |
---|---|
132 | |
52 | |
50 | |
36 | |
26 |