I want to set up a Power Automate flow that sends reminder emails for projects listed in a SharePoint list. Each project has a "Start Date" and a "Check Frequency (Days)" column. The flow should calculate if the current date falls on a day when a reminder is due based on the frequency value and then send an email to the responsible person listed for the project.
I have been using the Get Items function and it outputs the values that I want however when I try to use this as the input to a For Each loop it says the expression is invalid. I have also attached a photo of the current SharePoint List setup.
Are there any common pitfalls to watch out for when building these sort of flows?
Any help would be greatly appreciated.

Report
All responses (
Answers (