Get equal values from inside an array

Like (0) Share

Report

Posted on 16 Mar 2022 12:46:25 by JoaoSantos489

257

Hey guys.

So I have a variable array, named "Dias"with several values (dates - Name)

My question, Is there any way to get equal values from this array?

In this case I want to get the 2 equal dates "2022-03-21"

(Dates are not formated, I know)

Thanks in advance.

I have the same question (0)

All responses (3)

Answers (0)

fchopo 7,972 Moderator on 16 Mar 2022 at 15:52:22

Like (0)

Report

Re: Get equal values from inside an array

Hi @JoaoSantos489

You should do the following steps:

1) Initialize a variable to store dates (in my case, "Users").

2) Initialize a variable to store dates (in my case, "Users") and number of items.

3) Get Items from SharePoint list.

4) For each item in the SharePoint list

5) Store the items in Users array.

6) For each distinct user (using the union expression in the apply_to_each_2).

7) Get items with that Title (using filter query).

😎 Count the number of items and store it in the results table.

So at the end of the flow you will have a table with number of items for each Title (in my case).

Hope this helps!

Ferran

Was this reply helpful? Yes No
JoaoSantos489 257 on 16 Mar 2022 at 15:00:13

Like (0)

Report

Re: Get equal values from inside an array

Hey @fchopo thanks for your answer.

I understand the union function, but It´s the exactly opposite of it that I want.
I want to see the duplicated values

Was this reply helpful? Yes No
fchopo 7,972 Moderator on 16 Mar 2022 at 13:21:02

Like (0)

Report

Re: Get equal values from inside an array

Hi @JoaoSantos489

Using the union function you can remove equal values (distinct function). Here you have an excellent explanation: Get Distinct Records using the union expression in Power Automate - That API Guy

Can you apply these to an array with only the dates and after that append the title column?

Hope it helps!

Ferran

Was this reply helpful? Yes No