Formatting gift date in PowerAutomate

Krista Berg

Hello!
We are using PowerAutomate with NXT to create acknowledgement letters. I would like to include the gift date field but currently it pulls in a format that includes time. I cannot figure out how to format that field so that it doesn't show the timestamp. I am 100% a PowerAutomate newbie, though I have read through the BB documentation and watched the videos.

Thanks!
Krista

Dan Snyder

@Krista Berg Try this expression formatdatetime(outputs('Get_a_gift')?['body/date'],'MMMM d, yyyy').

Basically, you would need to change the Get_a_gift to the name of your action where you are pulling the date from. Also, for different date options you can use this guide. https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings