Hi All,
I'm new to power automate and i've set up a flow that should be working but in my view but it's not returning as I need it too.
The idea behind the flow is that I want an email to go out when a status changes within planner but first I need it to identify when a change takes place. I'm creating a sheet that holds when something is new and the previous status hoping that when something moves status it will record the current status allowing me to monitor.
In terms of an output - it's not returning the task name but i've identified that it's picking up the task names. It's not checking properly if it already exists and even before this if will always add the task to the sheet even if it already exists over and over and over again.