parameter default value

Question

parameter default value

arkiboys 9,706

Hello,
One of the pipeline parameter is pDate which I pass in manually each time I want o run the pipeline.
Is there a way to set the default of this parameter of the pipeline to be today's date?
When I hover over the textbox, I do not get a link for dynamic content.
Thank you

Accepted answer

1 additional answer

Your answer

Answer 1

Hi @arkiboys ,

Thank you for posting query on Microsoft Q&A Platform.

Parameters will not accept expressions as default value. So with parameter you cannot achieve getting current datetime as default value using utcnow() function.

You can consider having a variable for this requirement. For variable you can pass @{utcnow()} as default value that will set current date time vaule in that variable.

In below example, I created two variables "currentDateTimeVar" & "var2". I am setting default value for "currentDateTimeVar" as @{utcnow()}.
Now, using set variable activity I am trying to pass value of "currentDateTimeVar" in to "var2". This will help me to know @{utcnow()} function actually storing value in to "currentDateTimeVar" variable or not.

Hope this will help. Please let us know if any further queries.

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2021-09-17T12:28:45.123+00:00

Hi @arkiboys ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
arkiboys 9,706 Reputation points

2021-09-17T14:49:16.947+00:00

Thank you

Answer 2

Nandan Hegde 36,151 MVP Volunteer Moderator

Hey,
Unfortunately based on my understanding that is not possible.
So rather than referring your original parameter in your downstream queries, you can leverage a variable.

And that variable value would be parameter value which is passed out and it can be utcnow() in case if it is null.
And you can check whether a parameter is null by using equals and coalesce functions.

arkiboys 9,706 Reputation points

2021-09-13T16:30:00.767+00:00

can you let me know how to do this by an example?
Thank you
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator

2021-09-14T05:03:15.047+00:00
Hey,
You can use the below expression:

@if(equals(coalesce(pipeline().parameters.Test,'0'),'0'),utcnow(),pipeline().parameters.Test)

where pipeline().parameters.Test is the pipeline parameter

The above expression defines that in case if no specific parameter value is passed take utcnow else take the passed parameter value.

You can assign this expression to a variable in a set variable activity and leverage that variable in further activities rather than using the parameter value. (thereby achieving the goal)

Hope this clarifies :)

Share via

parameter default value

1 additional answer

Your answer