Daily Trigger TimeSpan and provide End date.

Write a power automate which will trigger daily, get the records from time stamp entity which records don’t have end date, update date end date and calculate the time?


Step 1 and 2: 


<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

  <entity name="effizz_timespan">

    <attribute name="effizz_timespanid" />

    <attribute name="effizz_name" />

    <attribute name="createdon" />

    <attribute name="effizz_start" />

    <order attribute="effizz_name" descending="false" />

    <filter type="and">

      <condition attribute="effizz_end" operator="null" />

    </filter>

  </entity>

</fetch>


Step 3 and 4:

In div take this value from expression :

div(div(mul(sub(ticks(formatDateTime(utcNow())),ticks(items('Apply_to_each')?['effizz_start'])),100),1000000000),60)







Comments

Post a Comment

Popular posts from this blog

If any case created, then check for the same user how many cases are created with in 30 days, if more than 2 and less than 5 send a mail to team lead, if more than 5 and less than 9 then send a mail to manager using power automate.

Image
If any case created, then check for the same user how many cases are created with in 30 days, if more than 2 and less than 5 send a mail to team lead, if more than 5 and less than 9 then send a mail to manager using power automate. Step 1 and 2: Step 3&4 Step 5&6 Step 6&7 Hear One condition will checks for cases are of greater than 2 or less than 5 and Second condition will check for cases are of greater than 5 and less than 9 check in you mail  which you provided
Read more

Create approve & reject ribbon buttons, once click on approve it should change the status field to approve.If clicked on reject it should change to Reject. Based on status field change trigger work flow to send a email to stating request is approved/Rejected.

Image
C reate approve & r eject ribbon buttons, once click on approve it should change the status field to approve. I f clicked on reject it should change to Reject . Based on status field change trigger work flow  to send a email to stating request is approved/Rejected. Ans. For doing this we should follow step wise Step 1: Create an entity name it as ApprovedBy. Step 2: Create a field name with status and data type as Option set Step 3: Create a new solution Next Inside solution add existing entity > Click on entity component > now click on Add existing entity > search Your entity > select that entity and click on ok > an entity assert pop up is visible In entity Asserts right side corner we can see two check box l  Include entity meta data l  Add all asserts     Now uncheck the Add all asserts > select the include entity metadata check box > Click on finish button > then  Missing required component pop up will be appear.   For ...
Read more

How to get and set values in plugins?

  How to get and set values in plugins?   Ans.   using System; using System.Collections.Generic; using System.Diagnostics; using System.IO; using System.Linq; using System.Net.NetworkInformation; using System.Text; using System.Threading.Tasks; using System.Xml.Linq; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Messages; using Microsoft.Xrm.Sdk.Metadata; namespace DatatypesPlugin {     public class UpdateData : IPlugin     {         public void Execute(IServiceProvider serviceProvider)                           {             IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));             IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));   ...
Read more