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:
  • Verified answer
    Pstork1 Profile Picture
    69,665 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 430

#2
11manish Profile Picture

11manish 341 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 282

Last 30 days Overall leaderboard