Logic Apps -- Dynamic function on (InitializeVariable)variables

Question

Hi ,
I used recurrent trigger but ran into issue due to schedule time drift. I was suggesting to try sliding window trigger and using @triggerOutputs()?['windowStartTime']" to retrieve the trigger time.

The trigger I created requires trigger date and time and passed it to KSQL query.
This is before:
TriggerDate"@{formatDateTime(utcNow(),'yyyy-MM-dd')}"
TriggerTime  "@{formatDateTime(utcNow(),'HH:mm:ss')}"
but I'm not able to make
Not working  “@substring(@triggerOutputs()?['windowStartTime'],0,9)”
Not working  @substring(@{variables('test')},0,9) ==> here test is InitializeVariable type is string, value is "@triggerOutputs()?['windowStartTime']"
...
...
Can anybody help ?

Thanks,
Ping

Answer 1

I'm able to figure it out after a lot of tries.

Remove @ instead dynamic function works.
work  “@substring(triggerOutputs()?['windowStartTime'],0,10)”
work  @substring({variables('test')},0,10)