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

Community site session details

Session Id :
Power Automate - Building Flows
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. 

 

I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,271 Most Valuable Professional on at
    Re: Get distinct values from array

    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
    Re: Get distinct values from array

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard