Unique Items in List

(1) Share

Report

Posted on by cmitchener

I have code in PowerApps that's just running too slow, so I need to find a way to convert some of it into Power Automate. After getting items from a SharePoint list, there a way to get just the unique/distinct Title values and bring them into a "collection" of sorts for me to evaluate as needed?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,454 Super User 2025 Season 2 on at

Like (0)

Report

Hi @cmitchener

ClearCollect(UniqueTitles, Distinct(TableName, FieldName));

Done

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
cmitchener on at

Like (0)

Report

I apologize, I meant is there a way to do that in Power Automate. I forgot to write that part in lol. I need to, in a flow, get the items from a list and take only the unique values in the Title field.

Was this reply helpful? Yes No
Michael E. Gernaey 53,454 Super User 2025 Season 2 on at

Like (1)

Report

Hi @cmitchener

yeah its important to put the details since folks like me help hundreds and its alot

But yes here is what you do in Power Automate

You have a list that has a column called Title

Add a Select action

In the Map field name put Title, in the Expression value put item()?['Title']

Make sure you put the value as an Expression not the text

After the Select add a Compose

If you look above, my select action is just called Select but you can rename it

In the compose put an expression that is this

union(body('Select'), body('Select'));

This will join it on itself and return ONLY a unique list of the TItle column

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
cmitchener on at

Like (1)

Report

Ok that worked to get the unique titles, how do I now evaluate those one at a time with a For Each? The flow doesn't like just plugging the compose output into the foreach evaluation.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,454 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Sorry you probably are done with this by now. However the outputs of the Compose would be exactly what you would put in.

I would need to see what you added there so I can tell you what the issue was. But I assure you the output is exactly what is needed, and is a pattern I've used and lots of other pros all the time

Was this reply helpful? Yes No