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!!! 😀
Solved! Go to Solution.
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
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:
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!
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
Subscribe : https://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
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
User | Count |
---|---|
19 | |
15 | |
14 | |
10 | |
8 |
User | Count |
---|---|
40 | |
30 | |
23 | |
21 | |
16 |