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
