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

Relationship Behaviours in D365 crm

Image
You will see the relationship options. Select the My Order Line related entity, then enter required fields, some of which will default and you can overwrite: Note the Relationship Behavior section. Selecting Parental, Referential or Referential, Restrict Delete will set the other fields to ready only and therefore non-configurable. Each behavior has pre-defined rules. Note the options for Parental: And Referential: And Referential, Restrict Delete: And Configure Cascading: Selecting Configurable Cascading will allow you change the configuration of most of the options, including: Assign, Share, Unshare, Reparent and Delete. Which means, when the parent record is assigned, shared, unshared, reparented or deleted, the system will perform the set cascade rules you set. Merge and Rollup View are still not configurable and are set to Cascade None: Note the options available depending on the action: Cascade All – this means the action is cascaded, i.e. if an action happens on the parent, do t...
Read more

Call Action Through JavaScript

Image
 How to Call Action Through JavaScript Ans. Step1: For this fi r st you need to create one action with Two  inputs and O ne output FirstName , LastName  as Inputs and FullName as Output. Next add step as assign value and set FirstName and LastName to FullName   After Creating  a JavaScript to call the action by using XRM toolbox var execute_new_CustomJsAct_Request = { // Parameters entity: { entityType: "effizz_customjs", id: "4f948776-05b6-ee11-9078-6045bd726ef9" }, // entity FirstName: "rtee", // Edm.String //change firstname value to fname LastName: "merr", // Edm.String // change lastname value to lname getMetadata: function () { return { boundParameter: "entity", parameterTypes: { entity: { typeName: "mscrm.effizz_customjs", structuralProperty: 5 }, FirstName: { typeName: "Edm.String", structuralProperty: 1 }, LastName: { typeName: "Edm.String", structuralProperty: 1 } }, op...
Read more

Power Apps Cheat Sheet

Problem Expression Show the current logged in user The User Function Examples User().Email - Shows email address User().FullName - Shows user's name User().Image - Shows user's photo Filter the rows to a certain criteria The Filter expression can filter the rows based on an expression of your choosing. Filter(DataSource, Expresssion) Filter( DataSourceName, Column > 0 ) Filter( DataSourceName, Column > 0, Column2 = "Value" )   Lookup a value in another table or source The lookup function can see the value from a different source based on an expression. Lookup(Source, Condition, ValueToShow) Lookup(DataSourceName, CustomerID = 5, CustomerName)     Create a Global Variable Global variables can be seen on any screen. They can be created when you start an app by selecting the App OnStart event or on any actionable event.   Set(VariableName, value)   Navigate to a new screen Navigation can be done two ways: either go back to the previous...
Read more