Pass Dynamic content from Trigger into pipeline for use

• GBeezy

  SSCarpal Tunnel

  Points: 4723

  More actions

  July 26, 2022 at 6:47 pm

  #4068542

  I am needing help in passing a dynamic value from the trigger into the parameters/variables of the ADF pipeline.  What I have so far is:

  1. A snapshot_date parameter
  2. A snapshot_date variable
  3. With a Set variable activity where my variable name is snapshot_date and the value is @pipeline().parameters.snapshot_date

  When I hit Debug at the top, I can simply place 2022-07-26 into the parameters of the pipeline and the output of the Set variable activity will show me that the value is 2022-07-26.

   

  However when I hit debug or when the trigger fires, I want to do something like: @formatDateTime(utcnow(), 'yyyy-MM-dd') or @formatDateTime(pipeline().TriggerTime, 'yyyy-MM-dd') or @formatDateTime(@trigger().startTime, 'yyy-MM-dd')

  And, if I attempt to use those three in debug mode or set the trigger to one of them I literally get that exact same string back as is, no date is being populated.

   

  How can I pass dynamic content from debug mode or the trigger parameters into my pipeline?

   

  Any and all help will be greatly appreciated.

   

  Thank you

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 27, 2022 at 7:10 pm

  #4069089

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.