How to get the lowest and highest values from an array of objects using Power Automate?

Ruthramugesh — Mon, 17 Mar 2025 16:11:50 +0000

Introduction:
In this article, we will explore how to retrieve the lowest and highest values from an array of objects using Power Automate expressions. By leveraging built-in functions, we can efficiently sort and extract the required values. This step-by-step guide, along with screenshots, will walk you through the process to achieve this seamlessly.

1. Store the array of objects in the Compose action.

2. Use the sort() expression in the Compose action to arrange the data in ascending order.

Expression for ascending: sort(outputs('Compose_-_Store_Array_of_Object'), 'LikesCount')
In the above expression, specify the property to sort in ascending order.

Below is the screenshot of the output sorted in ascending order.

3. Use the first() expression in the Compose action to get the lowest value from the array of objects.

Expression for first(): first(outputs('Compose_-_Sorted_in_Ascending_Order'))

Below is the screenshot of the output showing the lowest value based on LikesCount.

4. Use the reverse() expression in the Compose action to sort the array in descending order after sorting it in ascending order.

Expression for reverse(): reverse(outputs('Compose_-_Sorted_in_Ascending_Order'))

Below is the screenshot of the output sorted in descending order.

5. Use the first() expression in the Compose action to get the highest value from the array of objects.

Expression for first(): first(outputs('Compose_-_Sorted_in_Descending_Order'))

Below is the screenshot of the output showing the highest value based on LikesCount.

Conclusion:
By using the sort() expression, we can easily get the lowest value by sorting in ascending order. Similarly, by using the reverse() expression, we can sort in descending order to get the highest value. Finally, the first() expression helps retrieve either the lowest or highest value efficiently.

How to generate random colors in SPFx

Ruthramugesh — Thu, 13 Mar 2025 16:16:34 +0000

Introduction:
In this article, we dynamically generate random colors, assign them to a list of items, and apply the same color to duplicate items to improve the user experience in a SharePoint Framework webpart.

The following points will be discussed in detail:

Generate a unique color for each item.
Apply the Same Colors for Duplicate Items.
Highlight only the duplicate items.

These features help users quickly spot repeated entries, reduce confusion, and improve readability. Below is a step-by-step guide to achieving this.

1. Create a SharePoint Framework webpart project
2. Add a new functional react component. Under that add a state variables.

Generate a unique color for each item:

We use useState to store random colors for each item.

Random colors are generated using useEffect and stored in the state.

Add the below code in render function, which renders the Items with unique colors.

Below is the output showing unique colors for each item.

Apply the Same Colors for Duplicate Items:

We use useState to store random colors for each item.

Check if the item already has a color stored in userColorMap. If a color already exists for that item, retain the existing color; otherwise, generate a new random color.

Render duplicate items with the same colors.

Below is the output showing the same color applied to duplicate items.

Highlight only the duplicate items:

We use useState to store the count and color of duplicate items.

We use the userCountMap variable to count how many times an item appears. If an item appears more than once, We store its frequency and the generated random color in the state.

Render duplicate items by highlighting them with the same color, ensuring that each group of duplicates has a unique color.

Below is the output highlighting duplicate group items.

Conclusion :
The code generates random colors, assigns a unique color to each item, and ensures that the same item retains the same color throughout the list. Additionally, if an item appears more than once, it is highlighted using the same assigned color for consistency.

DEV Community: Ruthramugesh

How to get the lowest and highest values from an array of objects using Power Automate?

How to generate random colors in SPFx