Announcements
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.
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
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
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
