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

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

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