You are reading the article Power Automate Dynamic Content Overview updated in March 2024 on the website Hatcungthantuong.com. We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested April 2024 Power Automate Dynamic Content Overview
When selecting a field in a step during a flow creation, you’ll usually see a dynamic content panel. In this tutorial, we’ll discuss the Power Automate Dynamic Content, which lets users select field references from previous steps and even write expressions.
Dynamic contents are variables produced by triggers and actions within a flow diagram.
When we have this trigger, it searches tweets for the search term that we’ve set. After it finds the search term, it launches the flow, then captures dynamic content about that specific tweet.
After it goes through Twitter and finds a tweet with a “Power Automate” keyword, it will capture information such as who tweeted it, what their tweet was, the time of their tweet, the user ID of their tweet, and other data.
In case the trigger that we used is related to an email, then we can also get dynamic content about that email like the name of the sender, content of that email, subject line of that email, and many more.
As we can see, the available dynamic contents are related to our trigger. These dynamic contents could give us the tweet text, any URLs in the tweet, name of the user, location, username, user description, tweet ID, language code, and a lot more.
These dynamic contents are very important because it links the triggers and actions together. That’s important in almost all the flows that we’re creating.
Whatever flow we create, we need to create a link between the trigger that has been established and the action that we need to produce. This is evident not only in Twitter but also with other flows.
In this sample flow, the trigger that was used requires user inputs.
If we go over the action, we’ll see the dynamic contents that are related to emails such as the Email Subject and Email Body variables. These variables’ dynamic contents will come from the Subject and Body fields from the trigger.
In short, this trigger creates the dynamic contents which are the Email Subject and the Email Body that we can then use later in our actions.
Let’s try out other cool things with dynamic content. Firstly, let’s get the username. Type “User Name:”, and use the variable User name.
Make sure that it doesn’t have any warnings or errors.
This is a new flow so it doesn’t have the option for “Using data from the previous runs”.
We’ll need to perform the trigger action first when testing the flow before we can use the second option where we can use the data from the previous runs to automate the process.
This flow will now search Twitter and look for a tweet that contains our search text “Power Automate”. I’ll open up my Twitter now and tweet something that has a “Power Automate” text on it. In a few moments, we’ll see that our flow is running.
Then, it will display a notification saying that our flow ran successfully.
After that, let’s check our email and open the new message that we received.
As we can see, the body of the email contains the information that we’ve set on our flow. We have the “Tweet Information” and the “User Name:” which are the static text that we’ve set. Beside the “User Name:” is the actual username that I’ve used in my Twitter which is our variable for the dynamic content.
As a result, it matches the information that we’ve set on our flow diagram.
For this example, it replaces the username variable that was created within the trigger with the actual text in the email.
All in all, that’s how dynamic content works. It is a variable produced by triggers and actions within a flow diagram. It’s a very useful feature because it lets users select field references from previous steps or even write expressions.
Aside from customization, one great benefit of this feature is efficiency. By using dynamic content, you can set the value once, then reuse that variable whenever needed.
All the best,
You're reading Power Automate Dynamic Content Overview
In this blog post, I want to teach you how to show your customers moving through groups over time in a dynamic way. You can do this ranking visualization in Power BI using a unique slicer. You may watch the full video of this tutorial at the bottom of this blog.
The first thing we need to do is to create the underlying calculations. Since we already have the calculation for our revenue from This Quarter, we need to create the revenue calculations for the Previous Quarter and Two Quarters Ago.
I’ll create a new measure and name it as Revenue LQ. We’ll use the CALCULATE function, and reference the Total Revenue. Then use the DATEADD function, reference the Date table column, and then write minus 1 quarter.
The DATEADD function is such a good formula to use because of its flexibility to quickly change to any timeframe.
I’m going to copy this measure and paste it in the formula bar to create a new measure. Let’s call this one Revenue 2 Qs Ago, and then change the quarter from -1 to -2.
So now we’ve got all the revenues from the previous quarters. Let me just show you the revenue from last quarter.
The next step is to create a ranking formula that indicates how a client is ranked. We’ll create a new measure and call it Revenue Period Ranking.
To start things off, I’m going to use the RANKX function and reference ALL of my customers. Then I’ll write an expression, which is Total Revenue, and put it in a descending order.
Now we can see our clients’ ranking.
I also want to embed the ranking measure we’ve made into the Total Revenue by Customer Names visualization in the left so I’m going to use some variables.
I’m going with VAR then CurrentPeriodRank. The great thing about variables is that you can name them whatever you like.
Then I’ll copy this down twice in the formula bar and change their names to LastPeriodRank and TwoAgoPeriodRank.
Then I’m going to input the Revenue LQ and Revenue 2 Qs Ago calculations that we just did.
The next step is to match these up to whatever is selected in the slicer. We’ll use RETURN and then make a SWITCH TRUE statement.
We’ll use the SELECTEDVALUE function and reference Time Frame.
If the time frame is equal to this period, we want that to equal to CurrentPeriodRank.
At this point, I’m just bringing a lot of elements together here. I’m going to copy this portion of the formula twice.
I’m going to change This Period to This Quarter, Previous Quarter, and 2 Quarters Ago.
The key here is that no matter what selection we make in the Time Frame slicer, the numbers under the Total Revenue column shouldn’t change.
With Q2 2023 as the selected filter for Quarter & Year, this is the Total Revenue value for our customers and their ranking for This Quarter.
But we also want to see how these people ranked in the previous quarters. To do this, we just need to select the Previous Quarter and Two Quarters Ago from the slicer. Then the ranking number is going to change for each corresponding customer.
The last thing we need to do is go into the Data Color section, and then go to the Conditional Formatting area.
We’ll to the Rules section and then find the measure Revenue Period Ranking.
If the value of the number is greater than or equal to 1 and is less than or equal to 20, we want it equal to the darker blue color.
Let’s create a new rule. If it is greater than 20 and less than 20,000, then we want this to be equal to a much lighter blue color.
This is going to highlight the Total Revenue by Customer Names visual.
To come up with this group ranking visualization in Power BI report, we used a couple of different techniques. We have a supporting table which determined the metric we’re looking at. Then within the measure itself, we used logic derived from a variable. And then to finish it off, we used conditional formatting within the visual itself to showcase some interesting insight.
I hope that with this tutorial, you’ll be inspired on how you can carry out these techniques in your own reports. There are so many different ways that you can use logic like this. That’s definitely the key takeaway that I want you to learn from this tutorial.
If you liked this content, then watch the accompanying video and don’t forget to subscribe to Enterprise DNA TV.
For today’s blog post, I want to talk about a technique that we can use to simulate dynamic theming in a Power BI report. We’ve recently had a few posts on the Enterprise DNA support forum asking how to change the theme of a Power BI report dynamically. In one case, the user sought to have a single content page reflect the theme of multiple departments or categories. You can watch the full video of this tutorial at the bottom of this blog.
As of May 2023, only a single theme JSON file can be used in a Power BI report and a page can have only one background. This is why another technique is needed to accomplish the stated goal.
Here’s what I’ve come up with so far. This is a homepage that has four buttons on it.
There’s one for each category of shipment. If you hover over each category, you can see that the hover behavior is changing its transparency.
You can see that there are only two pages involved in this report. To build the solution, I started with a blank PBIX, then I added a small shipping data set based on the one we used in the recent Enterprise DNA challenge #12.
Then I searched online and found some images that represented the different shipping modes or categories. Then I followed it up by generating a basic color theme using the color theme generator in the Enterprise DNA Analyst Hub.
I chose medium dark blue as a starting point, then used the colors fan function to generate a six-color theme, which I then used to customize the theme of this Power BI report.
Finally, I developed a few DAX measures to return the text and background or font color using the themes desired. Let’s take a quick look.
We’ll open up our Key Measures, then go through our Color Measures folder. Theme Color 6 is just a hex code for one of my themes while Theme Color 5 is my medium blue starting color.
This has a value that is determined by the current category and created using a SWITCH TRUE statement.
If we look at the Table Title Font Background Colour measure, it uses exactly the same SWITCH TRUE statement based on category; but this time, it returns a color theme measure.
I have a similar measure for the color of the font, called Table Title Font Colour, which returns a wider black that contrasts well with the theme color.
And lastly, I have a Table Background Colour measure, which is a duplicate of my Table Title Font Background Colour measure but with a different name to make it easier to set up.
We also have a small table down at the bottom so we can see what the results of those measures are.
That’s it for the setup. Now let’s build the solution together and start with a Home page so that we’ve got something to navigate to.
We’ll create a Content 2 page and add an image for Home.
Bring the image into a corner, make it a bit smaller, and set its action to navigate to the home page.
Then we’ll add a slicer for categories and make the slicer single select.
The next step is to add a text box in the top left corner for the title. Let’s call it ABC Transportation and add a measure to our category.
The title changes when we make different selections on our slicer. We can also change the font color and size.
The next thing to do is add an image for each category. Let’s add the first image for air shipping. We’ll set it to size 1280 and 720 for full size. We’re going to name this in the selection pane.
We’ll do the same steps for the additional images and then add a table. Let’s add a new table to this table. We’ll put it in the category for us to be able to see from our shipments table, as well as the origin country and destination country. From our key measures category, we’re also going to add in the measures we’ve already calculated.
The next thing to do is to format the table. We will set the title text first to the measure that we have already calculated.
We can also change the table font color, table background, and transparency.
That’s it for the content page. Let’s move on to the homepage. To start, we’ll add a blank button here.
We’re going to turn off the outline and size it to 400 and 250.
We’ll set the image fit to fit and the transparency to 0% for On hover so we can see that the button becomes transparent when not selected.
The next step is to set the title. We can make it into a transparent color so we actually can’t see it.
We’ll do this for three more times by copying and pasting the image. Then we’ll adjust these to represent each category.
For the second button, we’re going to change the fill from air shipping to sea shipping.
Then change the image fit to fit and change the name. We’ll then change this background color to a different theme.
For the third button, we’ll change the fill from air shipping to road shipping.
Again, we’ll change the Image Fit to fit and change the title background color.
And for our final button, we will change the fill from air shipping to rail shipping.
And again, we need to set the image fit to fit and change the color of the background to a different theme.
As of May 2023, the current release of Power BI desktop allows the following properties to be set for the table:
The remaining properties cannot be programmatically set at this time. But if needed, one can leverage a solution using multiple table visuals, one for each category and then adjust the product properties and visibility individually as desired.
This can be a bit more complicated, but additional flexibility is possible. Experience shows that additional properties will become customizable in future releases of the Power BI desktop.
Hopefully, the Power BI team will add the ability to use multiple themes in a report. But for now, here’s one technique that allows you to simulate different themes.
Thanks for watching and I wish you all the best on your Power BI journey.
In this tutorial, we’ll look at a unique technique inside Power BI that allows us to create dynamic ranking tables using the RANKX function. You may watch the full video of this tutorial at the bottom of this blog.
What are Dynamic Ranking Tables?
Dynamic Ranking Tables showcase a range of information dynamically in a table, but the information shown is based off a specific ranking on a singular calculation.
We can look at the Top 20 Customers, based on Sales, across a range of other metrics, like Profits, Margin, Growth, etc. This technique will also automatically update the table after any change of context to the report page.
Let’s have a look at the Top 20 Customers in the table.
You can see the Profit Growth Year On Year table which requires the development of a few formulas to arrive at this measure. You can achieve these complex insights by overlaying the same techniques you would use when doing something relatively simpler.
In the formula for Profit Growth Year On Year, you can see that in evaluating a particular customer, it becomes ranked between a certain value based on a particular metric.
The filtering is done by using RANKX. The customer ranking is based on the Profit This Year versus Profit Last Year which will show the Profit Growth.
Ranking this particular measure will help you know which of these particular customers are within the Top 20 together with the specific results you want to highlight based on this metric.
You can see that the table only shows 20 results when there are, in fact, hundreds of customers. But because the customer data is isolated based on a specific metric, only 20 customers appear in the table.
Jumping to a different time frame will update the results but will still continue to show the Top 20 Customers.
You can also show the Top 20 Customers together with their Profit Growth and show other metrics to try and identify what caused the growth.
This growth in Profit could be due to an increase in Margins or an increase in Sales.
In the formula for Sales Growth Year On Year, you can see that the FILTER function has exactly the same structure as the previous formula, but instead of showing the Profit, it will display the Sales This Year versus Last Year.
This is going to evaluate to TRUE, which in this case is our customers. Then the same logic will play out so that profits between last year and this year stay within in the Top 20 metric.
That’s how you can isolate that particular insight and only show it for the most valued customers.
You can put Sales and Profit Growth in the Dynamic Ranking Table alongside The Top 20 Customers to gain better insights in your reports.
You can also do the exact same thing for Margin Growth.
You can see that the filtering done inside of CALCULATE is exactly the same as how it was done in the previous formulas.
Before, the Top Customers were only identified based on their Profit Growth. But now, the Margin metric can be isolated to see if the reason for the increase in Profit is due to the increase in Margins.
If you look at this table, you can see that the customer (EMD Group) has a negative Margins Growth.
However, you can see that despite having a negative Margins Growth, the customer continues to belong in the Top 20 because of its high Sales Growth resulting in high growths in Profits.
Simply looking at the table can give you more valuable insights into your reports and business.
When you set all this up in Power BI, you’ll see that it’s a great way of drilling into your top and bottom results.
This is a great way of incorporating a number of different measures and visualization techniques to create compelling reports that your consumers are going to love.
All the best,
Ubuntu After Install is a simple application that does just one thing: Automates the installation of useful extra software on your Ubuntu desktop. Here is how you can automate software installation after a fresh installation of Ubuntu.Installation
To install Ubuntu after install, simply add the following PPA (only available from Ubuntu 12.04 to 14.04):
Update your repository and install the application.
In case you are not able to add the PPA, you can install from the deb file found here (scroll down to the bottom of the page to download the deb file).
Note: It should work in other Ubuntu-based distros as well.Usage
When you run Ubuntu After Install (UAI), you will see a list of software on the screen. All of them are checked by default unless it has already been installed.
Here is the software included in UAI:
Ubuntu Restricted Extra
Unity Tweak Tool
Variety wallpaper changer
For applications that are not in your package manager, Ubuntu After Install will fetch the PPAs, add them to your repository, update your system and install the applications. It certainly saves you the effort of doing it on your own.Conclusion
You probably won’t be doing a fresh install of Ubuntu every day or month, but when you do, Ubuntu After Install is a useful tool for you to set up your desktop quickly and get back to working mode.
Damien Oh started writing tech articles since 2007 and has over 10 years of experience in the tech industry. He is proficient in Windows, Linux, Mac, Android and iOS, and worked as a part time WordPress Developer. He is currently the owner and Editor-in-Chief of Make Tech Easier.
Subscribe to our newsletter!
Our latest tutorials delivered straight to your inbox
Sign up for all newsletters.
Difference Between Static vs Dynamic Web Page
Web development, programming languages, Software testing & others
Dynamic web pages are written in languages like C++, Python, ASP. Net, AJAX, etc. Information like the weather forecast, social media posts, news channel, live updates of any tournament, which keeps on changing after every few seconds, comes under the dynamic web page because every time the user sends the request, the content to be displayed is changed on the web page.
Below are the top 7 comparisons between Static vs Dynamic Web Page:Key Differences Between Static vs Dynamic Web Page
Let us discuss some key differences between Static vs Dynamic Web Page in the following points:
2. Static web pages are not interactive, i.e. they display the same results every time a page is requested, whereas dynamic web pages take inputs from the user, processing them and displaying results accordingly
3. Static web pages are not scalable, i.e. if the user wishes to display various types of data to the client, a different web page is required for each type, whereas this can happen in a single dynamic web page by displaying the data according to the user requirements.
4. Real-time information through APIs and the data from the databases can be easily accessed in an organized and structured way through dynamic web pages, which is not possible in the case of static web pages that display the data statically and no interaction with the database and other APIs is possible.
6. Talking about the cost of creating both static and dynamic web pages, static web pages costs only at the starting of creation but ultimately, dynamic web pages cost much higher as the cost of functionality, database, and platform for writing the code is added.
7. In terms of simplicity, static web pages are very simple to create as newbies can easily create them in development, whereas strong server-side scripting knowledge, database knowledge and interaction between the two are needed in the case of dynamic web pages.Static vs Dynamic Web Page Comparison Table
The table below summarizes the comparisons between Static vs Dynamic Web Page:
Static web pages Dynamic web pages
A static web page’s content remains the same and does not change on any specific factor until the programmer/user changes it manually. The content of the dynamic web page keeps on changing depending on various factors.
The page loading time of a static web page is very less than that of a dynamic web page until very heavy images, videos, graphics are attached to the page. The page loading time of a dynamic web page is comparatively higher than that static web page as every time the processing written in the program is performed before displaying the web page.
Good programming knowledge is needed to create the logic of the dynamic web page.
No interaction with databases or other websites/servers is done in static web pages. Interaction with APIs, databases, other web servers are created in the case of dynamic web pages.
Content change rarely happens in the case of a static web page until the programmer changes the file manually. Content change frequently happens in the case of the dynamic web page as the server generates the new content every time the request is sent.
Used where only the informational part needs to be displayed to the client. Used when the interactive, changing and functional content needs to be displayed to the client.Conclusion
The above description clearly explains the difference between static and dynamic web pages. There is always confusion for the newbies in development between the two. Before programming or creating web pages, it is important to have in-depth knowledge of each terminology, like web pages, websites, web server, and client-server architecture, to understand things better. An important point to keep in mind regarding the static and dynamic web page is that both the pages’ response is the HTML content in the web browser through the HTTP protocol.Recommended Articles
This is a guide to the top difference between Static vs Dynamic Web Page. Here we also discuss the Static vs Dynamic Web Page key differences with Infographics and Comparison table. You may also have a look at the following articles to learn more –
Update the detailed information about Power Automate Dynamic Content Overview on the Hatcungthantuong.com website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!