Today I am writing about a simple tip about Power Automate trigger which exists from quite a while but many people might not know it…stop the suspense. Let’s get into the use case…for Power Automate flows running on a trigger..
Are you tired of making the action which triggers your flow each and every time, then you can use this tip..
Just click on Test from top right bar as below..
Then in the pop up menu, select Automatically and check With a recently used trigger.
Later you can select any of the recently successful or failed executions to re-trigger your flow, no more hassles or manual actions to trigger your flow.
Hope this helps some one…trying to re-trigger their Automated cloud flows…without invoking their flow using an actual trigger.
I believe ever Power Platform professional working on Dataverse had one or other time got a chance to work on calculated fields. Actually it provides an easy way to perform any calculations for the supported data types since it has been introduced with CRM Version 2015 update 1.
Here is a very simple example of simple calculation to get your Fx data type up and running in few seconds….follow along….
Open your solution, navigate to the columns in any table….for simplicity I am taking example of Accounts table…
Now create new column as below
Key values for the field, make a note that the data type (Fx) is selected
I already have two fields as below already on the form for calculating the Annual revenue per Employee from Annual Revenue of the company…
So now let’s write a simple Power Fx formula to calculate the Annual Revenue per Employee…the expression goes as below…
Annual Revenue is a currency field and Number of Employees field is single line of text. As soon as you save, system automatically identifies the data type as Decimal Number as shown above, click on save and publish the form…
Let’s see the actual use in the form…as soon as you enter the values for Annual Revenue and Number of Employees and save, the value for Calculated Revenue for the Employee field value will be calculated by the Power Fx expression.
Hope this will be useful in future for your implementations…
Points to keep in view:
This formula column is in preview right now at the time of writing this blog post.
And currently, formula columns can’t be used in roll-up fields or with plugins.
You can use the following operators in a formula column: +, -, *, /, %, ^, in, exactin, &
Microsoft Documentation says that the Currency data type isn’t currently supported but it works actually.
The Text and Value functions only work with whole numbers, where no decimal separator is involved
![Power Fx Fomula Data type – your new companion in addition to Calculated fields in Dataverse [Insight]](https://ecellorscrm.files.wordpress.com/2023/03/power-fx-template.png?w=1200)
ECELLORS CRM Blog 