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.
------------------------------------------------
⭐ If this was helpful, please like and mark as a verified answer to help others find this too!
Always glad to help! 💯💯💯💯💯
Tom
Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn