Forum Discussion

Mike Dumka's avatar
Mike Dumka
Iron Contributor
Apr 13, 2018

Formatting a date in Flow

I know this is crazy, but I using a flow that requires me to update a list with the value of a year. The problem is the users does not want '2018', they only want '18'. Based on the information I hav...
Microsoft Flow
SharePoint
  • Sandy Ussia's avatar
    Sandy Ussia
    Apr 17, 2018

    Hi Mike Dumka,

     

    You can use a custom date format to achieve this. 

     

    Using Flow's expression builder, select the formatDateTime function, insert in the ( ) the dynamic content token that contains the date from which you wish to extract the year, type a comma after that, and type 'yy' (in single quotes) to pull out the year. This is essentially formatting the date as year only.

     

    Does this help you?

     

    Sandy

     

Sandy Ussia's avatar
Sandy Ussia
MVP

Hi Mike Dumka,

 

You can use a custom date format to achieve this. 

 

Using Flow's expression builder, select the formatDateTime function, insert in the ( ) the dynamic content token that contains the date from which you wish to extract the year, type a comma after that, and type 'yy' (in single quotes) to pull out the year. This is essentially formatting the date as year only.

 

Does this help you?

 

Sandy

 

Resources