I want to create a Flow that will run daily. It will look through a Sharepoint list and send an email to the email addresses of any records that have a "notification date" value of today.
I have put together a Flow to achieve this, however when I go to save the Flow I get the followinh error: The template action 'Apply_to_each' at line '1' and column '1097' is not valid. Only actions of type other than 'scope', 'if', 'foreach', or 'until' are allowed to be nested under an action of type 'foreach'.
Firstly, I dont understand what this error is trying to tell me, and secondly, how do i overcome this?
My Flow looks like this;
- I started my flow with a Recurrence set to a one day interval.
- Next, a Get Items SharePoint action, linked to my list.
- Then I've set the following condition, ("PRNotificationDate" is the field in my sharepoint list)
- @equals(body('Get_items')?['PRNotificationDate'], utcnow('dd-mm-yyyy'))
- Then finally, under the IF YES option I put a Send Email action.