Yes, you can achieve this using Power Automate.
Please follow the steps below:
#1. Assume the RBLRefNo array is already stored in an array variable or a Compose action. if not, add a Compose action to store it.
For example, I stored the sample response in a Compose action to use later. My Compose Action Name is: Compose | RBLArray
#2. Get Unique RBLRefNo for this add a Compose action to get unique values using the union() expression:
Expression: (Please put this in expression)
union(outputs('Compose_|_RBLArray'),outputs('Compose_|_RBLArray'))
//outputs('Compose_|_RBLArray') - with the name of your variable or Compose action from the previous step.
#3. Declared variable with array data type. - This will store final data for the table.
#3. Loop through each unique value
- Add Apply to each loop action - Select the output of the Compose action (Get unique compose) as the input. - From Dynamic Selection
#4. Add Filter Array action inside the apply to each loop action
From: Select the array variable where you stored all RBLRefNo values (or the Compose output).
Use a condition to filter items equal to the current loop item
#5. Add Append to array variable action inside the apply to each loop.
#6. Add compose action to store the style
(Past below code)
<style>
table {
border-collapse: collapse;
width: 100%;
font-family: Arial, sans-serif;
}
table th, table td {
border: 1px solid #ddd;
padding: 8px;
text-align: left;
}
table th {
background-color: #4CAF50;
color: white;
}
table tr:nth-child(even) {
background-color: #f2f2f2;
}
table tr:hover {
background-color: #ddd;
}
</style>
#7. Add Create HTML Table action
From: Select the array variable that we have created above
#8. Add Send an email action
Output:
If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.
---------------------------------------------------------------------------------
📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.
✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.
💛 A Like always motivates me to keep contributing!
