How to get distinct values in a html text?

[ogh_sabyasachi]

Hi community,

I have an html text where I am filtering a collection and getting the list as in the attached screenshot.  Is there any way we can get the distinct values here.  For eg:  we want "HIPAA Rules & Regulations" just appear once.

[mdevaney]

@ogh_sabyasachi 
I think I know how to help you but I do not want to retype all of the code in your picture.  Please copy and paste your code as text into the forums and I'll make my suggestions.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[ogh_sabyasachi]

Hi @mdevaney ,

This is the html code I am using.  Hope this is helpful.  Please suggest the solution.  Thanks.

"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef' >
<td> Course Name </td>
</tr>
" & Concat(Sort(Filter(MyTempCol2, Full_Name in ([@PowerBIIntegration]).Data.Full_Name),FullNameOfCourse),

"<tr><td>" & FullNameOfCourse & " </td></tr>"
) & "
</table>"

[CarlosFigueira · Accepted solution]

You can use the Distinct function to retrieve only the unique values for the FullNameOfCourse column in your filtered expression:

"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef' >
<td> Course Name </td>
</tr>" &
Concat(
    Sort(
        Distinct(
            Filter(MyTempCol2, Full_Name in ([@PowerBIIntegration]).Data.Full_Name),
            FullNameOfCourse),
        Result),
    "<tr><td>" & Result & "</td></tr>"
) & "
</table>"

 Hope this helps!