⏰ In A Nutshell
Sorry but no. If the phone's power is turned off, it is technically impossible to activate the alarm.
⏰ To Elaborate
Such feature is only available for pre-loaded apps of certain manufacturers. According to their policy, third-party apps like Alarmy aren't able to provide it.
Please kindly understand.