I'm getting date from a SQL View and one if the field is a date (field called "startdate"). When I insert the field on an email I get this as example:
I need this to be formated as 2019-09-25
What would be the expression to use?
Add a compose step and use the expression below.
Above variable['StartDate'] map your StartDate from SQL View property.
Thanks for the reply. I'm not very familiar with the use of a Compose Step. I followed your suggestion but I'm stuck in "map your StartDate from SQL View property". Can you provide some additional details? Thanks!
I tried that but I'm facing this problem: I see the field "StartDate" within the dynamic content, but if I try to write the expression formatdatetime and try to get the field "StartDate", I don't see it. Sorry for the basic question....but what Am I doing wrong?
You can see two tabs there Dynamic Content and Expression
Click the expression and type formatDateTime()
Next place the cursor between the brackets of formatDateTime()
Next click the Dynamic Content. Click the Start property. This should be placed inside the above brackets of the expression function.
Hope it make sense.
The problem is when I go back to the Dynamic Content I don't see the StartDate Property. This is what I see:
I only see the StartDate Property when I click on the Dynamic Content tab without typing formatdatetime ():
Any clue what Am I doing wrong?
Thanks and sorry again for the basic questions!
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!