If the Motion Sensor didn’t cancel the motion detection 4 hours after last motion detection, then there seems to be a hardware problem, a problem with the Ubiquiti UniFi Protect App or some configurations of the MS are not correct. But because I don’t use this MS nor the UUP App, I don’t have any experiences with this and can’t give you some suggestions.
But in my opinion, these are the first things you should check.
If there are issues with the UUP App or you need some help regarding the UUP App, please continue in the corresponding topic: → [APP][Pro] Ubiquiti UniFi Protect
The second issue is, that your Advanced Flow is created incorrectly.
The used flow card The zone IS active is an And… flow card or also called Condition flow card.
Every flow must begin with a When… flow card, also called Trigger flow card. So something must happen or change to start a flow.
In your case the first flow card must be one of these here: The motion alarm turned on or The zone BECAME active.
To ensure that the light will be switched off again when no movement is longer detected, you need at least a second flow with an other When… resp. Trigger flow card: The motion alarm turned off, The zone became inactive or The zone became inactive since x minutes.
