Hi, everyone. I hope someone can help me on this.
I have a list on Sharepoint with several columns and one of them is called “Status”. Status can have only 4 options: “1 – Open”, “2- In Progress”, “3 – Sent to Client” and “4 – Closed Internally”. And I also have the columns “Final Deadline” and “Internal Deadline” (that is basically a date 15 days before the final date due).
What I'm trying to do is a flow that runs every day looking for actions that are still “1 – Open” or in “2- In Progress” and have the today’s “Internal Deadline”. Once it finds it, send an email for every person that the task is “Assigned to”.
This what I made but is not working. I don’t know if I should use 2 conditions or filter array and then a condition.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!