web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get distinct values fr...
Power Automate
Answered

Get distinct values from array

(0) ShareShare
ReportReport
Posted on by 74

All,

 

I'm struggling on capturing distinct values from an array. Data source is dataverse. Here's some screen shots:

 

smw356239_0-1682958270625.png

smw356239_1-1682958280801.png

 

The struggle is really the conditional statement. If a billing schedule number has multiple product plans (Product Plan is identified as an entry in the dataverse table) i.e., BSN000138 for Microsoft Corp and BSN000138 for Contoso Corp and both are under the MyCompany, the BSNXXXXXX should be unique. I'm trying to find the duplicates basically. I can provide further examples or explanation if this doesn't make sense. 

 

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,129 Most Valuable Professional on at

    The easiest way to get an array with the unique values from a particular array is to do a Union() with itself.  For example lets say I have an array that contains a person field.  

    1) Use Select to isolate the column that you want to retrieve the unique values from

    2) Add a Compose and insert a Union(<<outputStep2>>,<<outputStep2>>)

    The result is an array of the unique values from that column.  This screenshot shows how to get the unique list of users who have modified items in a SharePoint list.

    image.png

     

  • swebb111 Profile Picture
    74 on at

    Thank you for the help, I have some variation of this as the solution, but ultimately yes this is what I ended up doing. Thanks for the reply!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard