cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

How to concatenate a field that includes a date value from another field

Hi,

 

I have a requirement to populate a Dynamics name field with values from other fields, one of which is a Date field. I'm using the concat function already which is working fine but I can't get it to include the date value when it updates the field. It shows the value in the result but doesn't actually update the field. Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Re: How to concatenate a field that includes a date value from another field

I found the solution. There is a formatDateTime expression that allows you to append to utc(now). Once I added that to my concat statement, it worked.

View solution in original post

2 REPLIES 2
Highlighted
Helper II
Helper II

Re: How to concatenate a field that includes a date value from another field

OK I figured out how to get it to put the Date value in but now I have another challenge. The format is showing the entire timestamp along with the date but I need it to only show the date portion without the time. Is there a way to modify the variable to do this or possibly have another action that cleans up that value from the result in the text field?

Highlighted
Helper II
Helper II

Re: How to concatenate a field that includes a date value from another field

I found the solution. There is a formatDateTime expression that allows you to append to utc(now). Once I added that to my concat statement, it worked.

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,098)