Get distinct values from array

Like (0) Share

Report

Posted on 1 May 2023 16:30:37 by swebb111

All,

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

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.

All responses (2)

Answers (1)

swebb111 74 on 02 May 2023 at 13:16:17

Like (0)

Report

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!
Verified answer

Pstork1 66,209 Most Valuable Professional on 01 May 2023 at 16:41:40

Like (2)

Report

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.