cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArisTale
Helper I
Helper I

Can I concatenate 2 Date fields in a calculated column in Dataverse?

Hi, 

I am a new Dataverse user and looking for help here.

 

I have created a table (in Dataverse) and 2 columns by type Date Only: RA_EstimatedEntry and RA_EstimatedLeave

Now I need one more column to show a concatenation of these 2 dates like a period. Should I use a calculation for this? How?

 

For example, 

RA_EstimatedEntry - 01.01.2022

RA_EstimatedLeave - 15.01.2022

Period: 01.01.2022 - 15.01.2022

 

Thank you in advance!!! 😀

1 ACCEPTED SOLUTION

Accepted Solutions

@ArisTale 

Go to make.powerapps.com and open your solution and click add new item , Automation - process -workflow 

And you can learn more about realtime workflows from the link below:

https://docs.microsoft.com/en-us/power-apps/maker/data-platform/configure-workflow-steps

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

5 REPLIES 5
Mira_Ghaly
Dual Super User
Dual Super User

@ArisTale 

Unfortunately you can't use calculated column for this purpose, so alternatively you can create a new text column called Period and use a power automate flow on When a record is created and Set the field using a concatenate compose data operation (This is in case you do not want the change to be reflected immediately on the form)

Alternatively you can use a synchronous process - Workflow

Below is the sample of the work flow:

Mira_Ghaly_2-1648851959862.png

 

Mira_Ghaly_1-1648851827821.png

My recommendation is if you want it to be synchronous (immediate reflection) use Process as above , otherwise use Power automate as it will give you more flexibility if you wanna modify the format of the date.

 

Hope this gives you an idea and let me know if you need more help!

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
rampprakash
Super User
Super User

Hello @ArisTale 

 

As per CALCULATED FIELD, you can use only date and time for Calculation, 

 

Link for your reference : https://community.dynamics.com/crm/b/meganwalker/posts/difference-between-two-dates-with-calculated-...

 

Else as suggessted by @Mira_Ghaly  we are good to go with Realtime Workflow, else you can go with JavaScript.

 

Please mark as Answer if it is helpful and provide Kudos

 

Subscribehttps://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

 

 

Hi Mira,

 

Where can I find this Process settings? 

 

Regards,

Alexandra

Hi,

Can you elaborate more on Javascript? Any working solution?

 

Regards,

Alexandra

@ArisTale 

Go to make.powerapps.com and open your solution and click add new item , Automation - process -workflow 

And you can learn more about realtime workflows from the link below:

https://docs.microsoft.com/en-us/power-apps/maker/data-platform/configure-workflow-steps

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,459)